Become an Σxpert at Σxcel.com

Excel Sheets All Functions

Excel works on a file that is called a WorkBook.

Within an Excel file you can have one or multiple sheets aka Tabs, which can also go by the name Worksheet

What is a sheet?

a bunch of cells (rows and columns) organized by a name representing so sort of data like (to-do list)

Can store anything that's useful

Must save the Workbook which contains many Sheets or you'll lose the changes you made from last save

You access a sheet by clicking the tab at the bottom.

Select a sheet

find the tab and click it

It hides the sheet you were viewing and shows the sheet you've selected

Use Ctrl or Shift to select multiple sheets

Right click - Select All Sheets (lower left of the sheet)

Viewing a sheet
Excel shows only part of the whole worksheet depending on

Monitor size

Zoom setting

On my monitor I see Rows 1 - 30 and Columns A to X

Press Ctrl+Arrow keys to see how many cells there are

I see columns A - U and rows 1 to 29 at 100% view

Add a sheet aka Insert a sheet

Press the (+) button at the bottom of the spreadsheet

or Press Shift+F11

Naming a sheet

When you add a new sheet it will have a name like Sheet3

You should change this name to something that's useful to identify what's on the sheet

Ex. to-do list,

Sheet names are limited

Keep to under 30 characters
Certain characters aren't allowed

Active Sheet

This is the sheet you're currently working on

Selecting a sheet

Click the Tab

If you want to select multiple sheets you can hold the Shift or Ctrl key while clicking the sheet's tab

Rename a sheet

Double click tab text and type new name

or right click over tab and select rename

Types of sheets

Data

Pivot

Table lookup

Output from WebQuery

Chart

Tracking data

Row based data sheet

Delete a sheet

Right click and select Delete

Press OK

Hide/Unhide a sheet

Right Click the tab to hide

Select Hide

if data is in a hidden sheet the Find command won't find the data

Very Hidden sheets are hidden sheets - Right Click > View Code > Properties > Visible = 2 - xlSheetVeryHidden

to unhide

Right-click any tab

select the sheet to unhide

Move a sheet

Click the sheets Tab and use the move/copy dialog

Drag the tab and Drop it where to move it

Sheet names

Sheet names are limited to 30 characters

Certain character aren't allowed (/'* ...)

Sheet name must be unique

Find a sheet

Right click on the |< < > >|

Select the sheet

Press OK

Find data on a sheet

Ctrl+F for Find

Select Options

Select Within: and select WorkBook

Press Find All or Find Next

Copy a Sheet

To copy a sheet you right click the tab, select Move or Copy, click the Copy

You can move or copy the sheet to a new workbook if open

You can make a copy of a sheet and if you copy to the same workbook, if the name of the sheet is test Excel will name it test (2)

Tab Color

Right click > Tab Color

Sheet Options

Show/Hide Sheet Tabs - Advanced > Display options for this workbook

Show row and column headers

Show gridlines

Advanced - Display Options for this worksheet

Row and column headers

Gridlines

Outline symbol

Protect a Sheet

This allows you to prevent the user from changing parts of the sheet that could stop it from working

View Code

Each sheet can have code specific to it. Right-Click Tab and select View Code

Tab Names

in a formula without spaces Sheet!A1

spaces in a sheet name 'Sheet 1'!A1

in a different file '[c:\file.xlsx]Sheet 1'!A1

Indirect Formula to a sheet
=indirect("'sheet1'!A1")

is same as

=Sheet1!A1

Hyperlink to a sheet

Ctrl+K

Select Place in This Document on left

Select the sheet name