answersLogoWhite

0


Best Answer

Click on the Select All button. It is in the top corner of the spreadsheet, above the 1 for row 1 and to the left of the A for column A, and is a blank button. Clicking on that will select the entire worksheet.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

Ctrl-A will select all of the worksheet. Clicking on the box above the 1 for row 1 and beside the A for column A will also select the worksheet. Pressing ctrl-spacebar followed by shift-spacebar, or the other way around, will also select the entire spreadsheet.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Clicking the label at the left of the "A" label and on top of the "1" label.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

You can click on the column header. Another way is to press Ctrl - Spacebar and the current column that the cursor is in will be selected.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Either Ctrl+A or click the top left square, (not A1 but left and up from that, above the 1 and left of the A in the row/column headers) or press Ctrl-Spacebar and Shift-Spacebar in any order.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you highlight all the cells in a worksheet in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What cell does formulas and functions in Excel make use of?

Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.


Can data from Excel workbook be added to a PowerPoint slide?

Yes. You can add date from a MS Excel worksheet to a Power Point slide 2 ways. 1. You can highlight the cells you want to use and then copy and paste them to the slide. 2. You can create a table on the slide the same size and layout as the data in the Excel worksheet and copy/paste the data from the worksheet into the slide table either one at a time or all at once.


Explain how to clear a cell and a worksheet in Excel 2007?

The easiest and quickest way to clear an individual cell is to highlight the cell and press delete. To clear a range or an entire worksheet, highlight the cells you want to clear (there is no select all, as you would find in MS Word), and click on Clear | Clear All.In Excel 2007, you will find Clear on the ribbon tab Home (right side, in the editing section).In Excel 2003, you will find the Clear option under Edit | Clear | All.


When protecting a worksheet are all cells locked by default in Microsoft excel?

Yes, the default setting for protection on is all cells locked.


What does a WordArt text is called in Excel?

WordArt is text in a graphical form. There are many styles you can choose from including different colours, 3 dimensional text, text at different angles or curved or in wave shapes and so on. These are all styles.


How do you enter same value in every cell in Excel in mac entourage?

There is no direct connection between Excel and Entourage, but if you highlight all the cells from Excel and go to Entourage, you should be able to paste the data.


What is a grid in Excel?

When you look at a worksheet in Excel you can see all the cells, because of the lines around them. Those are gridlines. You can also add borders, to make heavier lines around cells. Gridlines can be turned off completely, by going to the Options menu and the View section and removing the tick beside Gridlines.


How many cells are there in a single Excel sheet?

In the Excel spreadsheet versions prior to 2002 or Office XP there are 65,536 rows and 256 columns , 65,536 x 256 = 16,777,216 cells or 'boxes'. Later versions of Excel have far more - millions of rows and thousands of columns. EDIT The latest version of Microsoft Excel that comes with Office 2007 has 17,179,869,184 cells in all. The columns are letter all the way to XFD and there are 1,048,576 rows.


How do you add a worksheet to Excel?

Right-click on any worksheet name tab and click Insert.Shift+F11Click on the Insert worksheet icon to the right of all the existing worksheet name tabs.


How can you protect a formula in excel just the formulas not the spreadsheet?

Format the entrie spreadsheet with all cells unprotected, except for the cells containing formulas you want to protect. When you turn on worksheet protection, only those cells that are formatted to be protected, will be protected.There are two steps to protecting a worksheet:Format the cells you want to protect. Default is protection on for all cells, so if you do not want a cell to be protected, you need to slect cell format and uncheck the option to protect that cell.Activate protection for the worksheet. Default is protection off for the worksheet.


What is spreadsheet software?

A spreadsheet software is a program or application that is used to organize, analyze and store information in a digital worksheet. This type of application is commonly used in financial computations and documentations.


What are the group of Excel functions that enable the user to retrieve information from defined areas of the worksheet?

All Excel functions allow you to retrieve information from different areas of a worksheet. See related links for a list of functions and their descriptions.