Skip to main content
Library Research Guides

Using Excel 2010 and 2013

This guide explains the basics of common features in Excel 2010 and 2013 for PC.

Welcome

This guide is intended to help you learn and become comfortable with Microsoft Word Excel 2010 or 2013 on the PC. Older versions or Mac versions of Excel may work in a similar way, but the steps might be different or certain features might be missing. Use the tabs above to browse the guide and be sure to check out the sources of extra help to the right.

If you are completely new to Excel and need a quick overview of its basic tools, please click here to see this screenshot. For help with printing and page break view, see the video below.

Shortcuts and Tips

Excel Shortcuts and Tips

Excel paste special

Paste Preview
After you copy data, right-click in the cell you would like to paste into. If you hover over one of the Paste Option icons, you will see a preview of what the data will look like. Are you pasting a formula? Do you want just the value of the cell?  To keep the same formatting?Once you choose, click the appropriate button to paste the data.

Shortcuts
In addition to the more common shortcuts such as copy, cut, paste, and save, Excel has a number of shortcuts that you will find helpful - some you may know, others maybe not!

  • To go up and down in the cells: Enter or Shift+Enter or arrow keys
  • To go right or left: Tab or Shift+Tab or arrow keys
  • To select all of the cells in a row or column that have data (vs. the whole column or row): Shift+Command+Arrow (Mac) or Shift+Control+Arrow (Windows)
  • To get the same content in multiple cells, highlight the cells, type in text/number and then press Control+Enter
  • Use lower right corner (AutoFill) of cell to fill down/across. If going down, you can double-click it instead (must be content to the cell to the left of this cell) (see tab above for more information)
  • The Esc key or red X in the Formula bar will abort your change.
  • Use absolute references to “lock” in a cell (for example =H2*$I$1)(see tab above for more information)
  • Use filters to quickly limit your view

Basic Formatting

Cells, Rows, and Column Formatting
From the Home Ribbon, you can format the font, number, alignment, border, pattern, and protection of your cells, rows, and columns.

You can also click on the Expand icon to open the traditional Format Cells dialog box that contains tabs for these various categories.

Worksheet/Page Setup
Just as the Home Ribbon provides you with the options that used to be only accessible in the Format Cells dialog box, the Page Layout Ribbon gives you access to features that used to be in the Page Setup dialog box (click on the Expand icon to access that traditional dialog box).

In the Page Setup Group, you canset the margins, orientation, and print area. Note that the Print Titles icon evokes the Page Setup dialog box, and that in this instance Print Titles refers to the row and column headings (e. g., A, B, C, 1, 2, 3, etc.) not the sheet‟s headers and footers. With the Page Setup dialog box open, you can click on the Header/Footer tab to change them. You can also access the headers and footers on the Insert Ribbon.

You can change a column's width by putting your cursor between the letter for that column and the next. When you get the two-headed arrow, drag to the right or left as desired.

Resizing Columns and Rows
Double-clicking on that same spot will “autofit” the column, making the column as wide as the largest piece of text/data in that column.

The same technique works for rows; put your cursor between the two numbers until you see the two-headed arrow, and then drag or doubleclick.

 

Hiding Rows and Columns
To hide a column or row, right-click on the letter or number for the column or row (A, B, C, etc. or 1, 2, 3, etc.) and select Hide.

To unhide a column or row, select the columns or rows before and after the missing column or row, right-click, and select Unhide.

Printing/Page Break View

To see where your data will split into multiple pages, go to the View Ribbon and click Page Break Preview icon in the Workbook Views Group. Adjust the page breaks by clicking and dragging the blue borders with your mouse. To return to the normal view, click on the Normal icon.

Watch the video for a demonstration of the steps described above.

Attend a workshop

University of Michigan Library
818 Hatcher Graduate Library South
913 S. University Avenue
Ann Arbor, MI 48109-1190
(734) 764-0400
contact-mlibrary@umich.edu
Copyright
Creative Commons

Except where otherwise noted, this work is subject to a Creative Commons Attribution 4.0 license. For details and exceptions, see the Library Copyright Statement. ©2015, Regents of the University of Michigan