When you are working on a huge spreadsheet ranging in several columns and rows, it becomes tough to work on and we need smart techniques to get difficult tasks done. Thankfully, Excel provides a lot of features and options to make it easier to work in and this is what makes it the undisputed king of spreadsheets.
We will learn one such technique today.
Suppose the document you are working on contains several formulas spread throughout the sheet and you want to select only those cells that contain a formula (maybe to highlight them with a background color, to make the text in all those cells bold, and so on).
Now, if you start to find the cells containing formulas manually it can take a lot of time and you may miss some of those. But you don’t really need to do this exercise manually (and look silly in the process!! ). Excel makes it simple to select all the cells with formulas in under 5 seconds.
Just follow the steps given below to select cells with formulas:
1. Press Ctrl G or F5 to open the ‘Go To’ dialogue box.
2. Click ‘Special…’ button
3. Select ‘Formulas’.
All cells in the worksheet containing formulas are selected by default. If you think appropriate you can exclude specific options: Number, Text, Logical, and Errors.
4. Click OK. All cells containing formulas would be selected, and you can now apply a specific background color, change font, or apply any other formatting to all of these together.
So above was the process to select all cells with formulas. Please post your comments below the post to share what you think about this post or about MadAboutExcel.
To follow MadAboutExcel on Facebook, click here.
To subscribe to the MadAboutExcel YouTube channel, click here.
See you soon in my next post. Till then take care and happy excelling!!
Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!
Subscribe to our newsletter and get interesting stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.