KEMBAR78
Quick Excel Tips - Customization | PDF
Scribd
Upload
5 views3 pages

Quick Excel Tips - Customization

This document provides quick tips for customizing and navigating in Excel, including how to hide gridlines, change the number of sheets in a workbook, and modify tab colors. It also covers navigation shortcuts such as searching for values, selecting rows and columns, and moving between worksheets. Additionally, it explains how to create bookmarks and hyperlinks within a worksheet.

Uploaded by

ykklds
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views3 pages

Quick Excel Tips - Customization

This document provides quick tips for customizing and navigating in Excel, including how to hide gridlines, change the number of sheets in a workbook, and modify tab colors. It also covers navigation shortcuts such as searching for values, selecting rows and columns, and moving between worksheets. Additionally, it explains how to create bookmarks and hyperlinks within a worksheet.

Uploaded by

ykklds
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Quick Excel Tips​

Options and Customization

1.​ Get rid of the grid! In newer versions of Excel, go to the View tab and uncheck

Gridlines. In Excel 2003, go to Tools > Options > View tab and uncheck Gridlines.

2.​ To change the default number of sheets in a new workbook, go to File > Options

> General and change the "Include this many sheets" setting

3.​ To change the background color of a worksheet tab, right-click on the tab and

select Tab Color.

4.​ Tired of seeing the green triangles in Excel? You can turn off specific

rules/warnings via File > Options > Formulas (or Error Checking in older

versions).

5.​ Before keying data into a table, highlight the range of cells to edit. Then use the

enter key to quickly move through just the highlighted region.


Quick Excel Tips​
Navigation and Selection
1.​ Use Ctrl+F to search a worksheet for a value. If you have a range selected, it will

search only that range. Handy for replacing values as well.

2.​ Use Ctrl+Arrow to jump between edges of occupied ranges. Add the Shift button

to highlight cells as you go.

3.​ Use Ctrl+G > Special to do things like Select all cells with comments, Select all

cells containing formulas, etc.

4.​ Use SHIFT+Space to select the current Row and CTRL+Space to select the

current Column. Remember which is which by noting that both "Ctrl" and

"Column" start with the letter "C".

5.​ Navigate to and Select a named range by pressing Ctrl+G to list the named

ranges. Click on the name you want to select and press OK. Useful for selecting

the current Print Area.

6.​ Move between tabs (worksheets) in Excel using Ctrl+PgUp and Ctrl+PgDn. In

Google Sheets, use Ctrl+Shift+PgUp and Ctrl+Shift+PgDn.

7.​ Move to a specific worksheet tab by right-clicking on the arrows to the left of the

tabs and selecting from the list.

8.​ Ctrl+Home takes you to cell A1. On a MacBook it's Fn+Cmd+LeftArrow

9.​ Create a bookmark by naming a cell. Select a cell to mark as a bookmark

location and enter a name such as "bm_1" in the Name Box (or by going to

Formulas > Define Name). Create a hyperlink in a cell or select a shape object to
turn it into a button by pressing Ctrl+k. Select "Place in This Document" and then

find and select the bookmark under Defined Names.

10.​[Info] In a protected worksheet, press Tab to navigate between input cells.

You might also like