How To Easily Select All Cells Containing Formulas

Published on January 16, 2017
image_pdfimage_print

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 EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!

Thank you for subscribing.

Something went wrong.

HUGE LIMITED TIME DISCOUNT ON THE BEST ADVANCED EXCEL COURSE ENROLL NOW!!
excel_look_professional
Making Excel Worksheets Look Professional – A Case Study
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
RANDOMIZE LIST RANDBETWEEN
Randomize a List in Excel Using RANDBETWEEN Function
FREEZE PANES
Freeze Panes in Excel – The Complete Guide
HOW TO LEARN EXCEL
How to Learn Excel and Be a Spreadsheet Champion
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
Pivot Tables
How To Convert Pivot Table Into Frequency Distribution
How to Convert Pivot Table into a Frequency Distribution in Excel

GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!

Thank you for subscribing.

Something went wrong.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
HOW TO SELECT CELLS CONTAING FORMULAS
"No Thanks. Please Close This Box!"