This article describes the formula syntax and usage of the SHEET function in Microsoft Excel.
Returns the sheet number of the reference sheet.
SHEET(value)
The SHEET function syntax has the following arguments.
Value Optional. Value is the name of a sheet or a reference for which you want the sheet number. If value is omitted, SHEET returns the number of the sheet that contains the function.
SHEET includes all worksheets (visible, hidden, or very hidden) in addition to all other sheet types (macro, chart, or dialog sheets).
If the value argument is not a valid value, SHEET returns the #REF! error value. For example, =SHEET(Sheet1!#REF) will return the #REF! error value.
If the value argument is a sheet name that is not valid, SHEET returns the #NA error value. For example =SHEET(“badSheetName”) will return the #NA error value.
SHEET is not available in the Object Model (OM) because the Object Model already includes similar functionality.
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Formula | Description | Result |
|---|---|---|
=SHEET(QSalesByRegion) | Returns the sheet number that contains the defined name QSalesByRegion on Sheet2, and has a scope that makes it available to the entire workbook. | 2 |
=SHEET(Table1) | Returns the sheet number that contains the table named Table1 on Sheet2, and has a scope that makes it available to the entire workbook. | 2 |
=SHEET(Hi_Temps) | Returns the #NAME? error value because the defined name Hi_Temps is limited to the worksheet that contains it, Sheet2. | #NAME? |
=SHEET('Stuff') | Returns the sheet number of the worksheet named Stuff. | 3 |
Microsoft Office is still the most popular office suite used by companies and individuals across the world. These Word, Excel, PowerPoint, and OneNote cheat sheets will help boost your productivity and save time when you’re working in these programs.
This post is part of Microsoft Office Week, a series at Lifehacker where we offer tips to get started with or master Microsoft Office. Want more? Check out the Office Week tag page.
Advertisement
Excel is packed with features spreadsheet ninjas should know, but for a visual reference, save or download one or all of these cheat sheets: 8 Great Tools to Make You an Excel Expert (includes how to combine cells, use VLOOKUP, and conditional formatting), Excel Tricks That Will Impress Your Boss (includes flash fill, pivot tables, and goal seeking), and 8 Time-Saving Excel Shortcuts (includes selecting the entire spreadsheet, resizing columns in just two clicks, and inserting the current date). They might sound the same, but they offer different tips and tricks. Excel has so many!
Advertisement
Excel’s keyboard shortcuts are similar on the PC and Mac, but not always. Some are quite different between the two OSes and others are Windows-only. The side-by-side comparison can help if you’re moving between the two operating systems.
Advertisement
New Horizons offers this printable PDF that covers frequently used Word, Excel, Outlook, and PowerPoint keyboard shortcuts. If you fold the paper along the lines and glue the edges, you’ll get a pyramid you can place in front of your keyboard for easy reference. (This one might be best for Office newbies.)
Advertisement
Microsoft offers three reference sheets for Excel, including Ctrl combinations, Function key combinations, and miscellaneous shortcuts. Though it’s for Excel 2010, they should apply to other versions of Excel as well.
AdvertisementPokemon black free download.
You might be familiar with PowerPoint’s keyboard shortcuts, but some tasks in PowerPoint require keyboard sequences—pressing two buttons together and then a third. As we’ve shared previously, Indezine offers a full list of these powerful sequences for PowerPoint 2016 and earlier, which you can check out here. There’s a printable e-book version for 2013 and earlier there as well.
Advertisement
I couldn’t find any Office for Mac cheat sheets, but did find this reference PDF that’s chock full of keyboard shortcuts for Office on the Mac, care of Dean Pirera at OS X Keyboard Shortcuts. They should help with any version of Office on the Mac.
Advertisement
Microsoft Word has over 200 keyboard shortcuts. If you’d like to see them all in one place, you can use a macro in Word to generate the list—or just download our PDF or Word version.
Advertisement
CustomGuide offers a ton of free cheat sheets for Microsoft Office, including Access and Office 2011 on the Mac. This might be the motherload of cheat sheets for Office.
Advertisement
Microsoft offers its own cheat sheets or quick reference guides for its Office suite, which you can view online or download as PDFs. They’re for Office 2016. MSDN also has the collection of 2013 quick start guides here.
Advertisement
This isn’t specific to Microsoft Office, but most of these common keyboard shortcuts can be used in Office as well as other programs, so they’re worth memorizing. Here’s our cheat sheet, from our guide to using keyboard shortcuts like a ninja. Download delphi 7 free.
Advertisement
Title image by Nick Criscuolo.