Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to apply conditional formatting on a sheet. I used to do Ctrl + A and then apply the formatting, but when i insert new cells or rows, this isn't included in the formatting. As you can see in the picture below, you have to give a range.

Conditional Formatting

Is it possible to give the entire sheet as range and how to do so?

share|improve this question
up vote 4 down vote accepted

For MS Office 2007 and later, use


to select all cells in the entire worksheet.

For MS Office 2003 and earlier, use


share|improve this answer
i thought there would be something like "worksheet" or something, but seems like there's not so i guess this will do. Thanks. – Terry Apr 29 '11 at 9:53
@djerry: You're welcome. If it was in VBA, there would be more options. – Mehper C. Palavuzlar Apr 29 '11 at 10:59
1:1048576 means all rows from row 1 to row1048576. 1048576 is 2^20. – user674669 Mar 14 at 0:55

A quick hack is to click the space above the intersection between first row & first column when prompted for a range to apply to

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.