How to Highlight All Data in Excel

submit to reddit

Submit Your Tip

How to Highlight All Data in Excel – This is a place for the community to provide tips and advice on How to Highlight All Data in Excel. This topic was created by Sanjay Sidhu and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Votes

Tips

1
- Vote
Tip 1
Select Rows, Columns, and Worksheets in Excel with Shortcut Keys More
Published: 9 years, 6 month(s) ago by Priscilla Belonio | permalink
Vote
Select all cells in a range or table of data in Excel using shortcut keys. Step by step instructions are included.

For further reading: http://spreadsheets.about.com/od/spreadsheetlessons/ss/Select-Rows-Columns-and-Worksheets-in-Excel-with-Shortcut-Keys_4.htm ^[1]

1
- Vote
Tip 2
10 top Excel keyboard shortcuts More
Published: 9 years, 6 month(s) ago by Stephen Leahy | permalink
Vote
Add date and time stamps, jump to next corner of a selection and more -- all with time-saving keyboard shortcuts from "Mr. Excel" Bill Jelen.

For further reading: http://www.computerworld.com/article/2488866/desktop-apps/10-top-excel-keyboard-shortcuts.html ^[2]

1
- Vote
Tip 3
A quick Excel keyboard trick for selecting large ranges More
Published: 9 years, 6 month(s) ago by Chris Lambert | permalink
Vote
You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range.

For further reading: http://www.techrepublic.com/blog/microsoft-office/a-quick-excel-keyboard-trick-for-selecting-large-ranges/ ^[3]

1
- Vote
Tip 4
Highlight Key Data With Excel Conditional Formatting More
Published: 9 years, 6 month(s) ago by George Mattos | permalink
Vote
Tutorial on how to use Excel conditional formatting rules to highlight key cells. This feature makes cells stand out for users. Includes related video.

For further reading: http://www.timeatlas.com/excel-conditional-formatting/ ^[4]

1
- Vote
Tip 5
Click to select row to end of data in Excel? More
Published: 9 years, 6 month(s) ago by Larry Mc Cann | permalink
Vote
In Excel, you can select an entire row by clicking its number at the left edge of the window. But doing so selects the entire row all the way to infinity. If you apply a fill color to a row select...

For further reading: http://superuser.com/questions/285316/click-to-select-row-to-end-of-data-in-excel ^[5]

About Author

More by Sanjay Sidhu

No more topics...

About This Topic

Category: Fun | 9 years, 6 month(s) ago

17.5k+ Reads

5 Tips

5 Votes

0 Likes

0 Saved

Contributors

Chris Lambert, Larry Mc Cann, George Mattos, Priscilla Belonio, Stephen Leahy

References & Citations

1. http://spreadsheets.about.com/od/spreadsheetlessons/ss/Select-Rows-Columns-and-Worksheets-in-Excel-with-Shortcut-Keys_4.htm

2. http://www.computerworld.com/article/2488866/desktop-apps/10-top-excel-keyboard-shortcuts.html

3. http://www.techrepublic.com/blog/microsoft-office/a-quick-excel-keyboard-trick-for-selecting-large-ranges/

4. http://www.timeatlas.com/excel-conditional-formatting/

5. http://superuser.com/questions/285316/click-to-select-row-to-end-of-data-in-excel