Excel 2010 Shortcuts

Excel 2010 Keyboard Shortcuts

Excel 2010 Shortcuts

MS-Excel has proven to be a very handy, useful tool. Some of the Excel 2010 keyboard Shortcuts tasks it can help with include: data imports and exports and Financial Reports.

To assist you with using MS-Excel, the following is a list of some shortcut keys for that software.  Find the ones you like and use away.

Ctrl + 0 - Hides the selected columns
Ctrl + 1 - Displays 'Format Cells' dialog box
Ctrl + 2 - Applies or removes bold formatting (Ctrl + B)
Ctrl + 3 - Applies or removes italic formatting (also Ctrl + I)
Ctrl + 4 - Applies or removes underlining (also Ctrl + U)
Ctrl + 5 - Applies or removes strikethrough
Ctrl + 6 - Alternates between hiding and displaying objects
Ctrl + 8 - Displays or hides the outline symbols
Ctrl + 9 - Hides selected rows
Ctrl + A - Selects entire worksheet
Ctrl + C - Copies selected cells
Ctrl + D - Uses Fill DOwn command to copy the contents and the format of the topmost cell of a selected range into the cells below
Ctrl + F - Displays Find and Replace dialog box, with Find tab selected
Ctrl + H - Displays Find and Replace dialog box, with Replace tab selected
Ctrl + K - Displays insert Hyperlink dialog box for new hyperlinks or Edit hyperlink dialog box for selected existing hyperlinks
Ctrl + L - Displays Create Table dialog box (also Ctrl + L)
Ctrl + N - Creates a new blank workbook
Ctrl + O - Displays Open dialog box to open or find a file
Ctrl + P - Displays Print tab
Ctrl + R - Uses Fill Right command to copy the contents and format of the leftmost cell of a selected range intot he cells to the right.
Ctrl + S - Saves the active file
Ctrl + V - Inserts contents of Clipboard at the insertion point and replaces selection. After cut/copy
Ctrl + W - Closes selected workbook window
Ctrl + Y - Repeats last command or action if possible
Ctrl + Z - Uses Undo command to reverse the last command or to delete the last entry that you typed
Ctrl + ; - Enters current date
Ctrl + '+' - Opens Insert dialog box
Ctrl + '-' - Opens Delete dialog box
Ctrl + PgUp - Switches between worksheet tabs, from left-to-right
Ctrl + PgDn - Switches between worksheet tabs, from right-to-left
Ctrl + Spacebar - Selects current column

That is some Basic Shortcuts of Excel 2010. Happy Excelling!

Read more »

Free Excel 2010 Tips

Excel 2010 Tutorial

We know that Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows us to store, manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers. 

Modifying Columns

When we open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells.

Modify Column Width

1. Position your mouse over the column line in the column heading so that the white cross becomes a double arrow.
    
   Positioning mouse over the column line
2. Click and drag the column to the right to increase the column width or to the left to decrease the column width.
    
   Increasing the column width
3. Release the mouse. The column width will be changed in your spreadsheet.
    
   Increased column width

To Set Column Width with a Specific Measurement:

1. Select the columns you want to modify.
2. Click the Format command on the Home tab. The format drop-down menu appears.
3. Select Column Width.
    
    Increasing the column width
4. The Column Width dialog box appears. Enter a specific measurement.
    
   Increasing column width to 258 pixels
5. Click OK. The width of each selected column will be changed in your worksheet.

Tips: Select AutoFit Column Width from the format drop-down menu and Excel will automatically adjust each selected column so that all the text will fit.

Visit this page for For modifying Excel 2010 Row .

Read more »

Excel Header and Footer

Header and Footer in Microsoft Excel 2010

We know that Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers and the date and time of printing. Unless you specify otherwise, Excel does not automatically add either a header or footer.

1. Click the Page Layout button on the View tab of the Ribbon.

Or you can click the Page Layout View button on the Status bar (It is the one in the middle).

2. Position the mouse pointer over the Click to Add Header section at the top, or in the Click to Add Footer section at the bottom.

Before you click one of these areas, decide whether you want your headers or footers on the left, on the right, or in the middle.

3. Click to position the insertion point in either the left, center, or right section of the header or footer area.

Excel adds a Header & Footer Tools contextual tab with its own Design tab.

4. Click the Design tab if it isn't already selected.

The Design tab is divided into Header & Footer, Header & Footer Elements, Navigation, and Options groups.

5. Click either the Header or Footer button (as appropriate) in the Header & Footer group at the left end of the Design tab.

The standard options for the Header or Footer appear in a drop-down list.

6. Click the header or footer example you want to use on the Header or Footer drop-down menu.

The option you selected now appears in the header or footer area of the worksheet. Repeat Steps 3–6 if you want to try another selection.

7. Click in the worksheet area and then click the Normal button on the View tab to return to Normal view.

You won't see the added header or footer in Normal view, but it's there when you preview or print the worksheet.
If, after selecting some stock header or footer info, you decide that you no longer need either the header or footer printed in your report, you can remove it. Simply click the (None) option at the top of the Header button's or Footer button's drop-down menus.

Read more »