Formatting and Editing Data

Here some of the shortcuts key for formatting and editing data for Macbook.

Working in cells or the Formula bar

Here shortcuts key for working in cells or the formula bar.

Entering data on a sheet

Here some of the shortcut key for entering data on a sheet.

Previewing and Printing

Here some shortcut key for previewing and printing if you use Macbook.

Moving and Scrolling in a sheet or workbook

Here some of the shortcut keys for moving and scrolling in a sheet or workbook on Mac.

Function Keys for Mac

Here some function keys for Mac.

Advanced Pivot Table Tasks

Creating a Slicer

Now in Excel 2016, you can multi-select slicers by clicking the button on the label as shown above. 

1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
   
2. Click Analyze > Insert Slicer. 
   
3. In the Insert Slicers dialog box, check the boxes of the fields you want to create slicers for.
4. Click OK. A slicer appears for each field you checked in the Insert Slicers dialog box. 
5. In each slicer, click the items you want to show in the PivotTable.

To choose more than one item, hold down Ctrl, and then pick the items you want to show.


Tip: To change how the slicer looks, click the slicer to show the Slicer Tools on the ribbon, and then apply a slicer style or change settings on the Options tab. 

Using the Slicer Tools Tab

To modify a slicer, click on the slicer and you will see the Slicer Tools ribbon containing Options tab.

Printing your Workbook

Print Commands

In Office, you can print and preview files from the same location by clicking File and then Print.

Print Preview

Excel combines Print and Preview in the same window.

1. Click File > Print. On the right, you’ll see a preview of your file. On the left, you'll see the Print button and the configurable Settings. 
2. Choose the number of copies you want. 
3. Look under Settings to choose other print options such as printing only certain pages, changing the page orientation, or printing two-sided. 
4. When you are ready, click Print. 
5. Click the arrow to return to your document.

Using Basic Print Options

Basic print options are available next to the preview.

• Print settings can also be found from the Page Layout tab.

Other Print Options

To access to more options, click on Page Setup on the bottom-right corner of the basic print options or by clicking on the dialog box launchers on the bottom-right corner of Page Setup, Scale to Fit and Sheet Options group in the Page Layout tab.

Excel Data Entry Tips and Techniques

There are excel data entry tips and techniques.

Other

= Starts a Formula


Ctrl + ` Toggles between the value layer and the formula layer


Ctrl + Insert Copies the current selection to the clipboard


Ctrl + Shift + ( Unhides any hidden rows within the selection


Ctrl + Shift + ) Unhides any hidden columns within the selection


Ctrl + Shift + Select unequal cells


Alt Toggles the activation of the old Menu Bar


Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box


Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box


Alt + Spacebar Activates the Control Box in the top left-hand corner


End Toggles between switching End Mode on or off


Scroll Lock Toggles between switching Scroll Lock on or off


Shift + Insert Pastes the entry from the clipboard

12 Basic Shortcuts That Will Make You An Excel Guru And Add Hours To Your Life

There are 12 basic shortcuts that will make you an excel guru and add hours to your life.

Formatting Data

Alt + ‘ Displays the Style dialog box


Ctrl + Shift + ( ‘ or ) Applies the Time format “hh:mm” to the selection


Ctrl + Shift + (1 or !) Applies the Comma separated format “#,##0.00” to the selection


Ctrl + Shift + (4 or $) Applies the Currency format “£#,##0.00” to the selection


Ctrl + Shift + (5 or %) Applies the Percentage format “0%” to the selection


Ctrl + Shift + (6 or ^) Applies the Exponential format “#,##E+02” to the selection


Ctrl + Shift + (# or ~) Applies the General format to the selection


Ctrl + (# or ~) Applies the Custom Date format “dd-mmm-yy” to the selection


Ctrl + Shift + (7 or &) Applies the outline border to the selection


Ctrl + Shift + (- or _ ) Removes all the borders from the selection

Maneuvering

Arrow Keys Moves to the next cell in that direction


Ctrl + Tab Moves to the next open workbook or window


Alt + Tab Moves to the next application open on your computer


Alt + Shift + Tab Moves to the previous application open on your computer


Enter Moves to the cell directly below


Tab Moves to the next cell on the right (or unprotected cell)


Home Moves to the first column in the current row


End + Arrow Keys Moves to the next non-empty cell in that direction


End + Enter Moves to the last cell in the current row that is not blank


End + Home Moves to the last used cell on the active worksheet*


End + Home Moves to the last used cell on the active worksheet*


Page Down Moves to the next screen of rows down


Page Up Moves to the previous screen of rows up


Shift + Enter Moves to the cell directly above (opposite direction to Enter)


Shift + Tab Moves to the cell directly to the left (opposite direction to Tab)


Alt + Page Down Moves you one screen of columns to the right


Alt + Page Up Moves you one screen of columns to the left


Ctrl + Home Moves to cell “A1” on the active sheet


Ctrl + End Moves to the last used cell on the active worksheet*


Ctrl + Up Arrow Moves to the first row in the current region


Ctrl + Down Arrow Moves to the last row in the current region


Ctrl + Left Arrow Moves to the first column in the current region


Ctrl + Right Arrow Moves to the last column in the current region


Ctrl + Page Up Moves to the previous worksheet in the workbook


Ctrl + Page Down Moves to the next worksheet in the workbook


Ctrl + Shift + Tab Moves to the previous open workbook or window


Scroll Lock + Arrow Keys Moves the workbook or window one cell the corresponding direction


Scroll Lock + End Moves to the last cell in the current window


Scroll Lock + Home Moves to the first cell in the current window


Scroll Lock + Page Down Moves you down one screen (current selection unchanged


Scroll Lock + Page Up Moves you up one screen (current selection unchanged)

Maneuvering (within a selection)

Enter Moves from top to bottom within a selection


Tab Moves from left to right within a selection


Ctrl + . Moves clockwise to the next corner within a selection


Shift + Tab Moves from right to left within a selection (opposite direction to Tab)


Alt + Ctrl + Left Arrow Moves to the left between non-adjacent cells in a selection


Alt + Ctrl + Right Arrow Moves to the right between non-adjacent cells in a selection