Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Thursday, July 5, 2018

FORMAT CHANGES USING EXCEL SHORTCUT KEYS

FORMAT CHANGES USING EXCEL SHORTCUT KEYS

(CTRL + ALT + V) + G
Purpose:Use this excel shortcut key to Paste merging conditional formatting of the destination and source ranges. The Paste all merging conditional formats option is only enabled when copying a range that contains conditional formatting.

(CTRL + ALT + V) + T
Purpose:Use this excel shortcut key to Paste format of the copied cell.

(CTRL + ALT + V) + W
Purpose:Use this excel shortcut key to Paste column widths

ALT + '
Purpose:Use this excel shortcut key to Display the Style dialog box

ALT + B
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box, add/remove bottom border

ALT + D
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box, add/remove downward diagonal border

ALT + H
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box and when more than 1 row is selected, add/remove horizontal interior border

ALT + H + 0
Purpose:Use this excel shortcut key to Increase the number of decimals displayed

ALT + H + 3 + D
Purpose:Use this excel shortcut key to Apply or remove double underlining

ALT + H + 5
Purpose:Use this excel shortcut key to Decrease indent of cell.

ALT + H + 6
Purpose:Use this excel shortcut key to Increase indent of cell.

ALT + H + 9
Purpose:Use this excel shortcut key to Decrease the number of decimals displayed

ALT + H + AB
Purpose:Use this excel shortcut key to Align text to the bottom of the cell

ALT + H + AC
Purpose:Use this excel shortcut key to Align text to the center (between left and right) of the cell

ALT + H + AL
Purpose:Use this excel shortcut key to Align text to the left of the cell

ALT + H + AM
Purpose:Use this excel shortcut key to Align text to the middle (between the top and the bottom) of the cell

ALT + H + AN
Purpose:Use this excel shortcut key to Choose accounting format

ALT + H + AN + M
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Number tab and the Accounting category selected

ALT + H + AR
Purpose:Use this excel shortcut key to Align text to the right of the cell

ALT + H + AT
Purpose:Use this excel shortcut key to Align text to the top of the cell

ALT + H + B
Purpose:Use this excel shortcut key to Expand Borders drop-down menu

ALT + H + B + A
Purpose:Use this excel shortcut key to apply All Borders to selected cell(s)

ALT + H + B + B
Purpose:Use this excel shortcut key to Bottom double border

ALT + H + B + C
Purpose:Use this excel shortcut key to Top and thick bottom border

ALT + H + B + D
Purpose:Use this excel shortcut key to Top and bottom border

ALT + H + B + E
Purpose:Use this excel shortcut key to Erase border of selected cells

ALT + H + B + G
Purpose:Use this excel shortcut key to Draw border grid for selected cells.

ALT + H + B + H
Purpose:Use this excel shortcut key to Thick bottom border

ALT + H + B + I
Purpose:Use this excel shortcut key to Choose border line color

ALT + H + B + L
Purpose:Use this excel shortcut key to Apply Left Border to all selected cells.

ALT + H + B + M
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Border tab selected

ALT + H + B + N
Purpose:Use this excel shortcut key to Apply No Border format to cell.

ALT + H + B + O
Purpose:Use this excel shortcut key to Apply Bottom Border to selected cells.

ALT + H + B + P
Purpose:Use this excel shortcut key to Apply Top Border to cell.

ALT + H + B + R
Purpose:Use this excel shortcut key to apply Right Border to selected content.

ALT + H + B + S
Purpose:Use this excel shortcut key to Apply Outside border to selected cells.

ALT + H + B + T
Purpose:Use this excel shortcut key to set Thick box border for selected cells

ALT + H + B + U
Purpose:Use this excel shortcut key to Top and double bottom border

ALT + H + B + W
Purpose:Use this excel shortcut key to Draw the border to selected cells.

ALT + H + B + Y
Purpose:Use this excel shortcut key to Choose border line style

ALT + H + E + F
Purpose:Use this excel shortcut key to Clear formatting of cells

ALT + H + FC
Purpose:Use this excel shortcut key to Expand Font Color drop-down menu

ALT + H + FF
Purpose:Use this excel shortcut key to Change the font face

ALT + H + FG
Purpose:Use this excel shortcut key to Increase the font size by 1 point

ALT + H + FK
Purpose:Use this excel shortcut key to Decrease the font size by 1 point

ALT + H + FM
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Number tab selected

ALT + H + FN
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Font tab selected

ALT + H + FP
Purpose:Use this excel shortcut key to Activate the Format Painter

ALT + H + FQ + D
Purpose:Use this excel shortcut key to Rotate text down in a cell

ALT + H + FQ + L
Purpose:Use this excel shortcut key to Rotate text in an angle clockwise

ALT + H + FQ + M
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Alignment tab selected

ALT + H + FQ + O
Purpose:Use this excel shortcut key to Rotate text in an angle counterclockwise

ALT + H + FQ + U
Purpose:Use this excel shortcut key to Rotate text up in a cell.

ALT + H + FQ + V
Purpose:Use this excel shortcut key to Rotate text so that it is vertical

ALT + H + FS
Purpose:Use this excel shortcut key to Change the font size

ALT + H + H
Purpose:Use this excel shortcut key to Expand Fill Color drop-down menu

ALT + H + H + N
Purpose:Use this excel shortcut key to Apply no fill color to current cell selection

ALT + H + J
Purpose:Use this excel shortcut key to Expand the Cell Styles menu

ALT + H + J + M
Purpose:Use this excel shortcut key to Display the Merge Styles dialog box to merge (copy) cell styles from another workbook

ALT + H + J + N
Purpose:Use this excel shortcut key to Display the Style dialog box to create a new cell style

ALT + H + K
Purpose:Use this excel shortcut key to Format number with a thousands comma (,) separator

ALT + H + L + C + E
Purpose:Use this excel shortcut key to Clear conditional formatting rules from entire worksheet

ALT + H + L + C + P
Purpose:Use this excel shortcut key to Clear conditional formatting rules from selected PivotTable. This option is only active when the active cell is within a PivotTable.

ALT + H + L + C + S
Purpose:Use this excel shortcut key to Clear conditional formatting rules from selected cells

ALT + H + L + C + T
Purpose:Use this excel shortcut key to Clear conditional formatting rules from selected table. This option is only active when the active cell is within a table.

ALT + H + L + D
Purpose:Use this excel shortcut key to Expand the menu to set a conditional formatting rule using data bars with gradient or solid fill

ALT + H + L + D + M
Purpose:Use this excel shortcut key to Display the New Conditional Formatting Rule dialog box, with the Format all cells based on their values rule type selected

ALT + H + L + H + A
Purpose:Use this excel shortcut key to Display the A Data Occurring dialog box to conditionally format cells whose date occurs within the time period set in the rule

ALT + H + L + H + B
Purpose:Use this excel shortcut key to Display the Between dialog box to conditionally format cells whose value is between the values set in the rule

ALT + H + L + H + D
Purpose:Use this excel shortcut key to Display the Duplicate Values dialog box to conditionally format cells with duplicate or unique values in the selected cell range

ALT + H + L + H + E
Purpose:Use this excel shortcut key to Display the Equal To dialog box to conditionally format cells whose value is equal to the value set in the rule

ALT + H + L + H + G
Purpose:Use this excel shortcut key to Display the Greater Than dialog box to conditionally format cells whose value is greater than the value set in the rule

ALT + H + L + H + L
Purpose:Use this excel shortcut key to Display the Less Than dialog box to conditionally format cells whose value is less than the value set in the rule

ALT + H + L + H + M
Purpose:Use this excel shortcut key to Display the New Conditional Formatting Rule dialog box, with the Format only cells that contain rule type selected

ALT + H + L + H + T
Purpose:Use this excel shortcut key to Display the Text That Contains dialog box to conditionally format cells whose text contains the text set in the rule

ALT + H + L + I
Purpose:Use this excel shortcut key to Expand the menu to set a conditional formatting rule using icon sets

ALT + H + L + N
Purpose:Use this excel shortcut key to Display the New Conditional Formatting Rule dialog box

ALT + H + L + R
Purpose:Use this excel shortcut key to Display the Conditional Formatting Rules Manager

ALT + H + L + S
Purpose:Use this excel shortcut key to Expand the menu to set a conditional formatting rule using color scales

ALT + H + L + T + A
Purpose:Use this excel shortcut key to Display the Above Average dialog box to conditionally format cells that are above the average in the selected cell range

ALT + H + L + T + B
Purpose:Use this excel shortcut key to Display the Bottom 10 Items dialog box to conditionally format cells that rank within the bottom values in the selected cell range

ALT + H + L + T + M
Purpose:Use this excel shortcut key to Display the New Conditional Formatting Rule dialog box, with the Format only top or bottom ranked values rule type selected

ALT + H + L + T + O
Purpose:Use this excel shortcut key to Display the Bottom 10% dialog box to conditionally format cells that rank within a certain bottom percentile in the selected cell range

ALT + H + L + T + P
Purpose:Use this excel shortcut key to Display the Top 10% dialog box to conditionally format cells that rank within a certain top percentile in the selected cell range

ALT + H + L + T + T
Purpose:Use this excel shortcut key to Display the Top 10 Items dialog box to conditionally format cells that rank within the top values in the selected cell range

ALT + H + L + T + V
Purpose:Use this excel shortcut key to Display the Below Average dialog box to conditionally format cells that are below the average in the selected cell range

ALT + H + M + A
Purpose:Use this excel shortcut key to Merge across cells. The selected cells in the same row are merged.

ALT + H + M + M
Purpose:Use this excel shortcut key to Merge cells

ALT + H + M + U
Purpose:Use this excel shortcut key to Unmerge cells from merged cells.

ALT + H + N
Purpose:Use this excel shortcut key to Choose number format

ALT + H + O + A
Purpose:Use this excel shortcut key to Auto-fit row height

ALT + H + O + H
Purpose:Use this excel shortcut key to Display the Row Height dialog box

ALT + H + O + I
Purpose:Use this excel shortcut key to Auto-fit column width

ALT + H + O + W
Purpose:Use this excel shortcut key to Display the Column Width dialog box

ALT + H + T
Purpose:Use this excel shortcut key to Expand Format as Table drop-down menu

ALT + H + T + N
Purpose:Use this excel shortcut key to Display the New Table Style dialog box

ALT + H + T + P
Purpose:Use this excel shortcut key to Display the New PivotTable Style dialog box

ALT + H + W
Purpose:Use this excel shortcut key to Wrap text of cell(s)

ALT + L
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box, add/remove left border

ALT + R
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box, add/remove right border

ALT + T
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box, add/remove top border

ALT + V
Purpose:Use this excel shortcut key to Within Border tab of Format Cells dialog box and when more than 1 column is selected, add/remove vertical interior border

CTRL + 1
Purpose:Use this excel shortcut key to Display Format Cells dialog box

CTRL + 5
Purpose:Use this excel shortcut key to Apply or remove strikethrough formatting

CTRL + B
Purpose:Use this excel shortcut key to Apply or remove bold formatting

CTRL + I
Purpose:Use this excel shortcut key to Apply or remove italic formatting

CTRL + SHIFT + !
Purpose:Use this excel shortcut key to Apply number format. Default settings are: (A) 2 decimal places, (B) 1000 separator, and (C) minus (-) sign for negative values

CTRL + SHIFT + #
Purpose:Use this excel shortcut key to Apply date format. Default setting is date, month and year

CTRL + SHIFT + $
Purpose:Use this excel shortcut key to Apply currency format. Default settings are: (A) 2 decimal places, (B) 1000 separator, and (C) negative values within parentheses ( )

CTRL + SHIFT + %
Purpose:Use this excel shortcut key to Apply percentage format. Default setting is without decimal places.

CTRL + SHIFT + &
Purpose:Use this excel shortcut key to Add outside borders to selected cell(s)

CTRL + SHIFT + @
Purpose:Use this excel shortcut key to Apply time format. Default settings are: (A) hour and minute, and (B) AM or PM

CTRL + SHIFT + ^
Purpose:Use this excel shortcut key to Apply scientific format. Default setting is with 2 decimal places

CTRL + SHIFT + _
Purpose:Use this excel shortcut key to Remove outside borders

CTRL + SHIFT + ~
Purpose:Use this excel shortcut key to Apply general format

CTRL + SHIFT + F
Purpose:Use this excel shortcut key to Display the Format Cells dialog box with the Font tab selected

CTRL + T
Purpose:Use this excel shortcut key to Display the Create Table dialog box

CTRL + U
Purpose:Use this excel shortcut key to Apply or remove underlining

F4
Purpose:Use this excel shortcut key to Repeat last command or action, when possible

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...