What are merged cells in excel

Five useful tips to assist overcome those commonplace excel issues. These tips include viewing all formulation on a worksheet, counting cells, printing remarks, viewing sheets and centring a identify.

What are merged cells in excel

1). View all Formulas on an Excel Worksheet

If you want to test where formulas exist on a worksheet without having to click on each cell, try out the following shortcut key to change the view of the Worksheet:

CTRL + ` (` Grave Accent secret's the one beneath the Escape Key on the a long way upper left facet of the keyboard)
Repeat the shortcut key to change the view again
2). Printing Comments in Excel

If you operate the Comments function in Excel, did you recognize that you can print out the Comments both as a list at the end of the sheet or as displayed at the spreadsheet - right here's how:

For Excel version 2003 or in advance:

Click the File menu and pick out Page Setup
Click the Sheet tab from the Page Setup dialog field
From the Comments listing field, select both At cease of sheet or As displayed on sheet:
Click OK
Print in the traditional manner
For Excel version 2007 or 2010:

Click the Page Layout tab from the Ribbon
Launch the Page Setup dialog box by way of clicking the arrow icon within the bottom proper-hand nook of the Page Setup institution:
Click the Sheet tab from the Page Setup conversation container
From the Comments list box, select both At cease of sheet or As displayed on sheet (see above picture)
Click OK
Print in the common way
three). Counting Cells in Excel

Let's imagine you have created a protracted list of product names in Excel. You recognise you are supposed to have 1254 products indexed but you're involved that you may have left a few out, or put a product in twice. So, you're going to must count number them, proper? Wrong! Or as a minimum, 'you' might not must be counted them... Excel will!

Excel offers many features to help you rely records this is contained in a spreadsheet. The most popular 3 are:

=COUNT This function will only matter cells within a particular list that comprise numbers. It will ignore empty cells, or people who comprise text
=COUNTA This function will count number cells that comprise numbers or text, however ignore empty cells
=COUNTBLANK This feature counts blank cells inside a particular range. So, for example, it helps you to understand how many entries are lacking.
Here's a display screen capture to reveal you each of the features, and the effects produced. Although the instance is based on a small spreadsheet with very basic cellular entries, the functions all work similarly nicely on a extra complex and big spreadsheet. Give them a cross!

Four). Viewing Sheets in Excel

Did you realize that you could view 2 or more sheets at the equal time in Excel as a substitute of getting to painfully maintain clicking among them? Here's how it is completed:

Open the spreadsheet that contains the sheets

For Excel version 2003 or in advance:

Click the Window menu and pick New Window
Click the Window menu and choose Arrange All
Choose a favored format i.E. Tiled and make certain Windows of active workbook is chosen:
Click OK
For Excel model 2007 or 2010:

Click the View tab from the Ribbon
Click the New Window icon
Click the Arrange All icon
Choose a desired format i.E. Tiled and ensure Windows of lively workbook is selected (see above image)
Click OK
You will now have Windows organized at the screen permitting you to view distinct sheets on the identical time. Please be assured that this process does not create two copies of your spreadsheet but alternatively two views - you're still operating on the identical spreadsheet.

5). Centre a Title in Excel

When you need to have a name above a facts table, it sometime seems better if it's far focused above the desk. See below instance:

To do that:

Type your title

Select the cells where the name is to be stretched throughout - within the above example, cells A1 to H1

In 2003 - Click at the Merge and Centre icon at the Formatting Toolbar

To cast off this formatting - preserve the identify location highlighted and press the equal Merge and Centre icon once more

In 2007/2010 - Click on the Merge and Centre icon at the Home Tab

To take away this formatting - preserve the name location highlighted and press the same Merge and Centre icon once more

In 2007, you also have further selections, inclusive of merge/ unmerge and many others. Click on the drop down arrow to the right of the Merge & Center icon to see the full variety of alternatives