How to Highlight All Data in Excel

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.

Tip 1 - Select Rows, Columns, and Worksheets in Excel with Shortcut Keys

Published: 9 years, 6 month(s) ago | Submitted by Priscilla Belonio | permalink

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]

Tip 2 - 10 top Excel keyboard shortcuts

Published: 9 years, 6 month(s) ago | Submitted by Stephen Leahy | permalink

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]

Tip 3 - A quick Excel keyboard trick for selecting large ranges

Published: 9 years, 6 month(s) ago | Submitted by Chris Lambert | permalink

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]

Tip 4 - Highlight Key Data With Excel Conditional Formatting

Published: 9 years, 6 month(s) ago | Submitted by George Mattos | permalink

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]

Tip 5 - Click to select row to end of data in Excel?

Published: 9 years, 6 month(s) ago | Submitted by Larry Mc Cann | permalink

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]