Accessibility shortcut keys

Report users can leverage the extensive range of keyboard shortcut keys for effortless accessibility. These include navigation keys to browse menus and shortcut keys to select cells, copy values, distribute totals, trigger writeback, add comments and much more.

1. Navigation Keys

ActionKeys for WindowsKeys for Mac

Move one cell up

Up arrow key

Up arrow key

Move one cell down

Down arrow key

Down arrow key

Move one cell left

Left arrow key / Shift + Tab

Left arrow key / Shift + Tab

Move one cell right

Right arrow key / Tab

Right arrow key / Tab

Move to the first cell in a row

Ctrl + Left arrow key

Cmd + Left arrow key

Move to the last cell in a row

Ctrl + Right arrow key

Cmd + Right arrow key

Move to the first cell in a column

Ctrl + Up arrow key

Cmd + Up arrow key

Move to the last cell in a column

Ctrl + Down arrow key

Cmd + Down arrow key

Move to the first cell of the first column

Home

Home

Move to the last cell of the last column

End

End

Move to the same field 10 records back.

Page Up

Page Up

Move to the same field 10 records forward.

Page Down

Page Down

Zoom in

Ctrl +

Option Cmd =

Zoom out

Ctrl -

Option Cmd -

Reset zoom

Ctrl + 0

Cmd + 0

Switch to previous tab

Ctrl + Page Up

Cmd + Page Up

Switch to next tab

Ctrl + Page Down

Cmd + Page Down

2. Selection Keys

ActionKeys for WindowsKeys for Mac

Extend the selection of cells by one cell to the left.

Shift + Left arrow key

Shift + Left arrow key

Extend the selection of cells by one cell to the right.

Shift + Right arrow key

Shift + Right arrow key

Extend the selection of cells by one cell to the top.

Shift + Up arrow key

Shift + Up arrow key

Extend the selection of cells by one cell to the bottom.

Shift + Down arrow key

Shift + Down arrow key

Extend the selection from the active cell to the first cell in a row

Ctrl + Shift + Left arrow key

Cmd + Shift + Left arrow key

Extend the selection from the active cell to the last cell in a row

Ctrl + Shift + Right arrow key

Cmd + Shift + Right arrow key

Extend the selection from the active cell to the first cell in a column

Ctrl + Shift + Up arrow key

Cmd + Shift + Up arrow key

Extend the selection from the active cell to the last cell in a column

Ctrl + Shift + Down arrow key

Cmd + Shift + Down arrow key

3. Menu Selection

ActionKeys for WindowsKeys for Mac

Go to Home Tab

Alt + H

Ctrl + H

Go to Insert Tab

Alt + I

Ctrl + I

Go to Design Tab

Alt + A

Ctrl + A

Go to Export Tab

Alt + X

Ctrl + X

4. Row Selection

ActionKeys for WindowsKeys for Mac

First Row

Alt + R + 1

Ctrl + R + 1

Second Row

Alt + R + 2

Ctrl + R + 2

Third Row

Alt + R + 3

Ctrl + R + 3

Fourth Row

Alt + R + 4

Ctrl + R + 4

Fifth Row

Alt + R + 5

Ctrl + R + 5

Sixth Row

Alt + R + 6

Ctrl + R + 6

Seventh Row

Alt + R + 7

Ctrl + R + 7

Eighth Row

Alt + R + 8

Ctrl + R + 8

Ninth Row

Alt + R + 9

Ctrl + R + 9

Multi-select Rows

Alt + M

Ctrl + M

5. Column Selection

ActionKeys for WindowsKeys for Mac

First Column

Alt + C + 1

Ctrl + C + 1

Second Column

Alt + C + 2

Ctrl + C + 2

Third Column

Alt + C + 3

Ctrl + C + 3

Fourth Column

Alt + C + 4

Ctrl + C + 4

Fifth Column

Alt + C + 5

Ctrl + C + 5

Sixth Column

Alt + C + 6

Ctrl + C + 6

Seventh Column

Alt + C + 7

Ctrl + C + 7

Eighth Column

Alt + C + 8

Ctrl + C + 8

Ninth Column

Alt + C + 9

Ctrl + C + 9

6. Toolbar View Shortcuts

ActionKey for WindowsKeys for Mac

Toggle to full view of toolbar

Ctrl + Shift + F

Cmd + Shift + F

Toggle to minimal view of toolbar

Ctrl + Shift + M

Cmd + Shift + M

7. Quick Formatting

ActionKeys for WindowsKeys for Mac

Open Quick Format menu

Alt + N + 0

Ctrl + N + 0

Uniform

Alt + N + 1

Ctrl + N + 1

Default/Measure Level

Alt + N + 2

Ctrl + N + 2

Auto

Alt + N + 3

Ctrl + N + 3

Native

Alt + N + 4

Ctrl + N + 4

8. Number Scaling and Formatting

ActionKey for WindowsKey For Mac

Open Number Scaling menu

Alt + S + 0

Ctrl + S + 0

None

Alt + S + 1

Ctrl + S + 1

Auto

Alt + S + 2

Ctrl + S + 2

Thousands

Alt + S + 3

Ctrl + S + 3

Lakhs*

Alt + S + 4

Ctrl + S + 4

Millions

Alt + S + 5

Ctrl + S + 5

Crores*

Alt + S + 6

Ctrl + S + 6

Billions

Alt + S + 7

Ctrl + S + 7

Trillions

Alt + S + 8

Ctrl + S + 8

Show the values in %

Ctrl + Shift + %

Cmd + Shift + %

Increase Decimal

Alt + H + 0

Ctrl + H + 0

Decrease Decimal

Alt + H + 9

Ctrl + H + 9

*Not Applicable

9. Conditional Formatting

ActionKey for WindowsKey For Mac

Open Conditional Formatting Panel / Add new rule

Alt + Y

Ctrl + Y

Apply Heat Map

Alt + Y + 1

Ctrl + Y + 1

Apply ABC Classification

Alt + Y + 2

Ctrl + Y + 2

Apply Data Bars

Alt + Y + 3

Ctrl + Y + 3

10. Applying Templates

ActionKeys for WindowsKeys for Mac

Open Templates window

Alt + T

Ctrl + T

Apply Template T01

Alt + T + 1

Ctrl + T + 1

Apply Template T02

Alt + T + 2

Ctrl + T + 2

Apply Template T03

Alt + T + 3

Ctrl + T + 3

Apply Template T04

Alt + T + 4

Ctrl + T + 4

Apply Template T05

Alt + T + 5

Ctrl + T + 5

Apply Template Matrix

Alt + T + 6

Ctrl + T + 6

Apply Template Spreadsheet

Alt + T + 7

Ctrl + T + 7

Apply Template Simple

Alt + T + 8

Ctrl + T + 8

Apply Template Standard

Alt + T + 9

Ctrl + T + 9

11. Alignment, Decimals and Other Formatting

ActionKeys for WindowsKeys for Mac

Bold

Ctrl + B

Cmd + B

Italic

Ctrl + I

Cmd + I

Underline

Ctrl + U

Cmd + U

Text Strikethrough

Ctrl + H

Cmd + H

Align Left

Alt + H + A + L

Ctrl + H + A + L

Align Right

Alt + H + A + R

Ctrl + H + A + R

Align Center

Alt + H + A + C

Ctrl + H + A + C

12. Row Expand/Collapse Options

ActionKey for WindowsKey For Mac

Expand Row Level

Alt + Right arrow key

Ctrl + Right arrow key

Collapse Row Level

Alt + Left arrow key

Ctrl + Left arrow key

Expand All

Alt + Up arrow key

Ctrl + Up arrow key

Collapse All

Alt + Down arrow key

Ctrl + Down arrow key

13. Manage Aggregation

ActionKey for WindowsKey For Mac

Open Aggregation window

Alt + K

Ctrl + K

Native aggregation

Alt + K + 1

Ctrl + K + 1

Sum

Alt + K + 2

Ctrl + K + 2

Minimum

Alt + K + 3

Ctrl + K + 3

Maximum

Alt + K + 4

Ctrl + K + 4

Average (Children)

Alt + K + 5

Ctrl + K + 5

Average (Leaf)

Alt + K + 6

Ctrl + K + 6

Standard Deviation

Alt + K + 7

Ctrl + K + 7

Visible Rounding

Alt + K + 8

Ctrl + K + 8

14. Other Inforiver Actions

ActionKey for WindowsKey For Mac

Add Comment

Ctrl + M

Cmd + M

Post Comment

Ctrl + Enter

Cmd + Enter

Open Comments Panel

Alt + S + P

Ctrl + S + P

Close Comments Panel

Esc

Esc

Display the added comment in a cell

Shift + F3

Shift + F3

Assign a user

Tab/Alt + A + U

Tab/ Ctrl + A+ U

Add Note

Shift + F2

Shift + F2

Add Prefix/Suffix

Alt + J

Ctrl + J

Open Top N Filter

Alt + N + R

Ctrl + N + R

Create Advanced/Nested Filter

Alt + V

Ctrl + V

Create Group

Alt + W

Ctrl + W

Export to PDF

Alt + P

Ctrl + P

Export to Excel

Alt + X + L

Ctrl + X + L

Export Config

Ctrl + G

Cmd + G

Border Style

Ctrl + L

Cmd + L

Change Layout Style

Alt + B

Ctrl + B

Invert Sign

Alt + O

Ctrl + O

Insert Quick Formula

Alt + Z

Ctrl + Z

Open Audit Log

Alt + U

Ctrl + U

Reset All Changes

Ctrl + Shift + H

Cmd + Shift + H

Quick Access Shortcuts Help

Ctrl + F

Cmd + F

15. Writeback Shortcuts

ActionKeys for WindowsKeys for Mac

Trigger Writeback

Alt + WB

Ctrl + WB

Confirm Pop-up message

Enter

Enter

Close/Cancel Pop-up message

Esc

Esc

16. Status Bar - Row & Pagination Settings

ActionKey for WindowsKey For Mac

Hide pagination and row count

Alt + L + 0

Ctrl + L + 0

Show Pagination Controls and Total Row Count

Alt + L + 1

Ctrl + L + 1

Split Report to 10 rows per page

Alt + L + 2

Ctrl + L + 2

17. Other Common Shortcuts

ActionKey for WindowsKey For Mac

Undo

Ctrl + Z

Cmd + Z

Redo

Ctrl + Shift + Z

Cmd + Shift + Z

Select All

Ctrl + A

Cmd + A

Clear Activity / Close Modal

Esc

Esc

Delete Selection

Del or Backspace

Del

Cut

Ctrl + X

Cmd + X

Copy

Ctrl + C

Cmd + C

Paste

Ctrl + V

Cmd + V

Copy to Clip Board

Ctrl + C + L

Cmd + C + L

Last updated