Excel 2016

Ctrl + ;

Add current date

Ctrl + Shift + ;

Add current time

Exporting workbooks

By default, Excel workbooks are saved in the .xlsx file type. However, there may be times when you need to use another file type, such as a PDF or Excel 97-2003 workbook. It's easy to export your workbook from Excel to a variety of file types.

Ctrl+C

Copy selected text

To modify column width:

Double click right boundary of column heading and it will fit it for you (right boundary of column heading is where the columns are labeled "A,B,C, etc...")

To export a workbook to other file types: You may also find it helpful to export your workbook to other file types, such as an Excel 97-2003 workbook if you need to share with people using an older version of Excel, or a .CSV file if you need a plain-text version of your workbook.

1.Click the File tab to access Backstage view. 2.Click Export, then select Change File Type. 3.Select a common file type, then click Save As. 4.The Save As dialog box will appear. Select the location where you want to export the workbook, enter a file name, then click Save. * You can also use the Save as type: drop-down menu in the Save As dialog box to save workbooks in a variety of file types.

To export a workbook as a PDF file: Exporting your workbook as an Adobe Acrobat document, commonly known as a PDF file, can be especially useful if you're sharing a workbook with someone who does not have Excel. A PDF will make it possible for recipients to view but not edit the content of your workbook.

1.Click the File tab to access Backstage view. 2.Click Export, then select Create PDF/XPS. 3.The Save As dialog box will appear. Select the location where you want to export the workbook, enter a file name, then click Publish. * By default, Excel will only export the active worksheet. If you have multiple worksheets and want to save all of them in the same PDF file, click Options in the Save As dialog box. The Options dialog box will appear. Select Entire workbook, then click OK.

To change the default save location: Computer

1.Click the File tab to access Backstage view. 2.Click Options. 3.The Excel Options dialog box will appear. Select Save, check the box next to Save to Computer by default, then click OK. The default save location will be changed.

To modify all rows or columns: Instead of resizing rows and columns individually, you can modify the height and width of every row and column at the same time. This method allows you to set a uniform size for every row and column in your worksheet. In our example, we will set a uniform row height.

1.Locate and click the Select All button just below the name box to select every cell in the worksheet. 2.Position the mouse over a row line so the cursor becomes a double arrow. 3.Click and drag the mouse to increase or decrease the row height, then release the mouse when you are satisfied. The row height will be changed for the entire worksheet.

Sharing workbooks: Excel makes it easy to share and collaborate on workbooks using OneDrive. When you share a workbook from Excel, you're actually giving others access to the exact same file. This lets you and the people you share with edit the same workbook without having to keep track of multiple versions.

* In order to share a workbook, it must first be saved to your OneDrive. 1.Click the File tab to access Backstage view, then click Share. 2.The Share pane will appear. If you have not already done so, you will be prompted to save your document to OneDrive. Note that you may need to navigate back to the Share pane after saving. 3.On the Share pane, if your document is saved to OneDrive, click the Share with People button. 4.Excel will return to Normal view and open the Share panel on the right side of the window. From here, you can invite people to share your document, see a list of who has access to the document, and set whether they can edit or only view the document

AutoRecover: Excel automatically saves your workbooks to a temporary folder while you are working on them. If you forget to save your changes or if Excel crashes, you can restore the file using AutoRecover.

1.Open Excel. If autosaved versions of a file are found, the Document Recovery pane will appear. 2.Click to open an available file. The workbook will be recovered. ! By default, Excel autosaves every 10 minutes. If you are editing a workbook for less than 10 minutes, Excel may not create an autosaved version. 3.If you don't see the file you need, you can browse all autosaved files from Backstage view. Just select the File tab, click Manage Versions, then choose Recover Unsaved Workbooks.

To continue a series with the fill handle: The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In most cases, you will need to select multiple cells before using the fill handle to help Excel determine the series order. Let's take a look at an example:

1.Select the cell range that contains the series you want to continue. In our example, we'll select E4:G4. 2.Click and drag the fill handle to continue the series. 3.Release the mouse. If Excel understood the series, it will be continued in the selected cells. In our example, Excel added Part 4, Part 5, and Part 6 to H4:J4. * You can also double-click the fill handle instead of clicking and dragging. This can be useful with larger spreadsheets, where clicking and dragging may be awkward.

To merge cells using the Merge & Center command:

1.Select the cell range you want to merge. In our example, we'll select A1:F1. 2.Click the Merge & Center command on the Home tab. In our example, we'll select the cell range A1:F1. 3.The selected cells will be merged, and the text will be centered.

To wrap text in cells:

1.Select the cells you want to wrap. In this example, we'll select the cells in column C. 2.Click the Wrap Text command on the Home tab. 3.The text in the selected cells will be wrapped. * Click the Wrap Text command again to unwrap the text.

To hide and unhide a row or column: At times, you may want to compare certain rows or columns without changing the organization of your worksheet. To do this, Excel allows you to hide rows and columns as needed. In our example we'll hide a few columns, but you can hide rows in the same way.

1.Select the columns you want to hide, right-click the mouse, then select Hide from the formatting menu. In our example, we'll hide columns C, D, and E. 2.The columns will be hidden. The green column line indicates the location of the hidden columns. 3.To unhide the columns, select the columns on both sides of the hidden columns. In our example, we'll select columns B and F. Then right-click the mouse and select Unhide from the formatting menu. 4.The hidden columns will reappear.

To center across selection: Merging can be useful for organizing your data, but it can also create problems later on. For example, it can be difficult to move, copy, and paste content from merged cells. A good alternative to merging is Center Across Selection, which creates a similar effect without actually combining cells.

1.Select the desired cell range. In our example, we'll select A1:F1. Note: If you already merged these cells, you should unmerge them before continuing to step 2. 2.Click the small arrow in the lower-right corner of the Alignment group on the Home tab. 3.A dialog box will appear. Locate and select the Horizontal drop-down menu, select Center Across Selection, then click OK. 4.The content will be centered across the selected cell range. As you can see, this creates the same visual result as merging and centering, but it preserves each cell within A1:F1.

To move a row or column: Sometimes you may want to move a column or row to rearrange the content of your worksheet. In our example we'll move a column, but you can move a row in the same way.

1.Select the desired column heading for the column you want to move. 2.Click the Cut command on the Home tab, or press Ctrl+X on your keyboard. 3.Select the column heading to the right of where you want to move the column. For example, if you want to move a column between columns E and F, select column F. 4.Click the Insert command on the Home tab, then select Insert Cut Cells from the drop-down menu. 5.The column will be moved to the selected location, and the columns around it will shift. * You can also access the Cut and Insert commands by right-clicking the mouse and selecting the desired commands from the drop-down menu.

To access more merge options: If you click the drop-down arrow next to the Merge & Center command on the Home tab, the Merge drop-down menu will appear.

From here, you can choose to: Merge & Center: merges the selected cells into one cell and centers the text Merge Across: merges the selected cells into larger cells while keeping each row separate Merge Cells: merges the selected cells into one cell but does not center the text Unmerge Cells: unmerges selected cells * You'll want to be careful when using this feature. If you merge multiple cells that all contain data, Excel will keep only the contents of the upper-left cell and discard everything else.

Ctrl + 1 for quick number-formatting options

Select desired cells and press CTRL + 1

Wrapping text and merging cells

Wrapping text and merging cells Whenever you have too much cell content to be displayed in a single cell, you may decide to wrap the text or merge the cell rather than resize a column. Wrapping the text will automatically modify a cell's row height, allowing cell contents to be displayed on multiple lines. Merging allows you to combine a cell with adjacent empty cells to create one large cell.

Using number formats correctly

X ✔️ Wrong Right Date January 1st 1/1/2014 Percent. 50 50% Time Noon 12:00 pm

Ctrl + V

to paste