Shortcut Key For Adding New Row In Excel Macos

11-05-2021 admin

Shortcut Key For Adding New Row In Excel Mac Os 10
Shortcut Key For Adding New Row In Excel Mac Os Free
Shortcut Key For Adding New Row In Excel Mac Os Print Scale To Fit

Open a page to create a new record; the same way as choosing the New action. Alt+Shift+N: Close a page and open a new one to create a new record; the same way as selecting the OK & New action. Alt+Shift+W: Open the current card or document in a new window. For more information, see Multitasking Across Multiple Pages. Ctrl+Enter: Save and close.

-->

This article provides an overview of some of the shortcut key combinations that you can use when you're working with Business Central.

For an overview of the most popular keyboard shortcuts, see Keyboard Shortcuts (PC only).

Tip

For a graphical view of the most used shortcuts, choose the following image and download the PDF file.

Overview

Keyboard shortcuts aid accessibility and can make it easier and more efficient to navigate to different areas and elements on a page. They're supported by most web browsers, however, the behavior may vary slightly.

In this tutorial, learn the useful methods to add new row in Excel sheet. Insert the new row with an only keyboard shortcut of computer or laptop. Many users using mouse buttons and few clicks to add single or multiple rows. However, you can use only the keyboard shortcuts given here which are unknown but easiest methods.
Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula.
Aug 05, 2019 There are always differences between the PC and Mac versions of Excel, beyond the fact that Microsoft usually delays the Mac version of Excel by a year from the PC version (I believe they do that for the Office suite purely for marketing reasons.

Note

The keyboard shortcuts described here refer to the U.S. keyboard layout. The layout of the keys on other keyboards may not correspond exactly to the keys on a U.S. keyboard.

Most of the shortcuts are the same whether the operating system is Windows or macOS. However, some shortcuts differ for macOS. These shortcuts are indicated with brackets in the following sections.

Note

In addition to the global keyboard shortcuts described in this topic, a number of business-specific shortcuts are available. For example, in the generic version of Business Central, F9 posts a document and Ctrl+F7 shows the financial entries for a record. (These may be different in your solution.) The keyboard shortcut is shown in the tooltip for the action in question.

General Keyboard Shortcuts

The following table describes keyboard shortcuts for navigating and accessing different elements of a page. Elements include things like actions, drop-down lists, lookups, and more. For details about keyboard shortcuts for navigating records once you get inside a list, see the next section.

Press these keys (in macOS)	To do this
Alt+Down Arrow	Open a drop-down list or look up a value for a field.
Alt+Up Arrow	Show tooltip for a field or a column header of a table. If the field has validation errors, press Alt+Up Arrow to show the validation error. Press Esc or Alt+Up Arrow to close the tooltip.
F2	Toggle between selecting the entire field value or placing the cursor at the end of the field value.
Alt+F2	Show and hide the FactBox pane.
Alt+Shift+F2	Shift between Details and Attachments in the FactBox pane.
Alt+O	Add a new note for the selected record, even if the FactBox pane isn't open.
Alt+Q (Ctrl+Option+Q)	Open the Tell Me window. For more information, see Finding Pages and Information with Tell Me.
Alt+N	Open a page to create a new record. (Similar to choosing the New and + actions.)
Alt+Shift+N	Close a newly created page and open a new one to create a new record. Similarly, Alt+F9 posts a document and creates a new one.
Alt+T	Open the My Settings page.
Alt+Right Arrow	Look up additional information or underlying values for a field that contains the button. This is used when the usual drop-down button (Alt+Down Arrow) in the same field is used for another purpose.
Shift+F12	Open the role explorer, a feature overview. For more information, see Finding Pages with the Role Explorer.
Ctrl+Alt+Shift+C	Display information in the company badge.
Ctrl+Alt+F1	Open and close the page inspection pane. The page inspection pane shows information about the page, like its source table, fields, filters, extensions, and more. For more information, see Inspecting Pages.
Ctrl+C	Copy the value of field. If the field is in focus, and you haven't selected any text in the field, this will copy the entire value. If you've selected any text in the field, then it will copy the selected text only.
Ctrl+F1	Open the Business Central help for the page.
Ctrl+F12	Switch between wide and narrow layout view.
Ctrl+Click	Navigate during personalizing or customizing when the action is highlighted with an arrowhead. For more information, see Personalize Your Workspace.
Ctrl+F5	Reload the Business Central application. (Similar to selecting refresh/reload in the browser.)
F5	Refresh the data on the current page. Use this key to ensure that the data on the page is up to date with any changes that others have made while you're working.
Enter	Enable or access the element or control that is in focus.
Esc	Close the current page or drop-down list.
Tab	Move focus to the next control or element on a page, such as actions, buttons, fields, or list headings.
Shift+Tab	Move focus to the previous control or element on a page, such as actions, buttons, fields, or list headings.
Y and N	Activate Yes and No buttons in dialog boxes. Actual keys will vary based on your current language specified in My Settings. For example, press J to activate the Ja button when using German language.

Keyboard Shortcuts in Lists

The following table describes the keyboard shortcuts that you can use on a list page. The shortcut action is slightly different depending on whether the page is shown in the list view or tile view.

[!Note]> In the table that follows, the term *actionable field* refers to a field on which you can do something, like change a value or link to another page. In general, the shortcuts will skip over fields that display information that you cannot change from the list (in other words, fields that are read-only).-->

General

Press these keys (in macOS)	To do this in a list view	To do this in a tile view
Alt+F7	Sort the selected column in ascending or descending order.	Not applicable.
Alt+N	Insert a new line in an editable list, such as the G/L Budgets page.	Same.
Shift+F10	Open a menu of options that are available for the selected row.	Same.

Navigating Between Rows and Columns

Grids containing rows and columns exist on many page types in Business Central, such as list pages and Lines parts on documents. Moving from one cell to another across a grid is fully keyboard-enabled.

Press these keys (in macOS)	To do this in a list view	To do this in a tile view
Ctrl+Home (Fn+Ctrl+Left Arrow)	Select the first row in the list; focus remains in the same column.	Move to the first tile in the first row.
Ctrl+End (Fn+Ctrl+Right Arrow)	Select the last row in the list; focus remains in the same column.	Move to the last tile in the last row.
Home (Fn+Left Arrow)	Move to the first field in the row.	Move to the first tile in the row.
End (Fn+right Arrow)	Move to the last field in the row.	Move to the last tile in the row.
Enter	Open the record that is associated with the field. Only relevant if a card page is associated with the record.	Opens the record. Only relevant if a card page is associated with the record.
Ctrl+Enter	Move focus to the next element outside the list.	Move focus to the next element outside the list.
Page Up (Fn+Up Arrow)	Scroll to display the set rows above the current rows in view.	Scrolls to display the set of tiles above the current tiles in view.
Page Down (Fn+Down Arrow)	Scroll to display the set rows below the current rows in view.	Scroll to display the set of tiles below the current tiles in view.
Down Arrow	Move in the same column to the field in the row below.	Move in the same column to the tile in the row below.
Up Arrow	Move in the same column to the field in the row above.	Move in the same column to the tile in the row above.
Right Arrow	In a view-only list, move in the same row to the next field to the right. In an editable list, move to the right within the current field.	Move in the same row to the next tile to the right.
Left Arrow	In a view-only list, move in the same row to the previous field to the left. In an editable list, move to the left within the current field.	Move in the same row to the previous tile to the left.
Tab	In editable list, move in the same row to the next field to the right.	Not applicable.
Shift+Tab	In editable list, move in the same row to the previous field to the left.	Not applicable.

Selecting, Copying, and Pasting

Press these keys (in macOS)	To do this in a list view	To do this in a tile view
Ctrl+Click (Cmd+Click)	Extend the selection of rows to include the row that you click.	Not applicable.
Shift+Click	Extend the selection of rows to include the row that you click and all the rows in between. You can use this after using Ctrl+Up Arrow or Ctrl+Up Down to expand your selection.	Not applicable.
Ctrl+Up Arrow (Ctrl+Cmd+Up Arrow)	Move focus to the row above and keep the current row selected.	Not applicable.
Ctrl+Down Arrow (Ctrl+Cmd+Down Arrow)	Move focus to the row below and keep the current row selected.	Not applicable.
Ctrl+Space Bar (Ctrl+Cmd+Space)	Extend the selection of rows to include the focused row. You can use this after using Ctrl+Up Arrow or Ctrl+Down Arrow to expand your selection.	Not applicable.
Ctrl+A	Select all rows.	Not applicable.
Ctrl+C (Cmd+C)	Copy the selected rows to the Clipboard.	Yes, but only for a single selected tile.
Ctrl+V (Cmd+V)	Paste the selected rows from the Clipboard into the current page or external document, like Microsoft Excel or Outlook email. You can only do this in editable lists.	Not applicable.
Shift+Up Arrow	Extend the selection of rows to include the row above.	Not applicable.
Shift+Down Arrow	Extend the selection of rows to include the row below.	Not applicable.
Shift+Page Up (Shift+Fn+Up Arrow)	Extend the selection of rows to include all visible rows above the current selection of rows.	Not applicable.
Shift+Page Down (Shift+Fn+Down Arrow)	Extend the selection of rows to include all visible rows below the current selection of rows.	Not applicable.
F8	Copy the field in the same column of the row above, and paste it into the current row. You can only do this in editable lists. Using this shortcut followed by a Tab lets you quickly fill out fields in line items that you want to have the same value as the row above.	Not applicable.

Searching and Filtering Lists

Press these keys (in macOS)	To do this
F3	Toggles the search box. Activate the search box, so you can start typing your search text. If the search box is already activated, F3 returns to the list without clearing the search text.
Shift+F3	Open and close the filter pane. If the filter pane isn't open, Shift+F3 opens it and focuses on the + Filter action under Filter list by. You can then just hit Enter to start adding a field filter. If the filter pane is already open, Shift+F3 closes it but doesn't clear any filters that you've added.
Ctrl+Shift+F3	Open and close the filter pane. If the filter pane isn't open, Ctrl+Shift+F3 opens it and focuses on the + Filter action under Filter total by. You can then just hit Enter to start adding a totals filter. If the filter pane is already open, Ctrl+Shift+F3 closes it but doesn't clear any filters that you've added.
Alt+F3	Toggle filtering to the selected value. Applies a column filter on the selected field value in the list. This does the same as choosing Filter to this value from a column heading. It opens the filter pane, sets filter to the selected value, while focus remains on cell in the list. If the column is already filtered, Alt+F3 clears the filter on that column.
Shift+Alt+F3	Open the filter pane and add a filter on the selected column in the list. Focus is on the new filter field, which lets you start typing the filter criteria right away. This does the same as selecting Filter from the column heading. If there is already a filter on the field, a new filter is added.
Ctrl+Shift+Alt+F3	Reset filters. This does the same as choosing Reset filters in the filter pane, and it applies to field and totals filters. Filters return to the default filters for the current view. If the current view is All, then this is the same as returning to an unfiltered view with all records.
Ctrl+Enter	Change focus from the filter pane back to the list.

Keyboard Shortcuts in Cards and Documents

The following shortcuts are available on card pages, such as Customer Card, and document pages, such as Sales Order, to display and modify records.

Press these keys (in macOS)	To do this
Alt+F6	Toggle collapse/expand for the current FastTab or part (subpage).
Alt+N	Open a page to create a new record; the same way as choosing the New action.
Alt+Shift+N	Close a page and open a new one to create a new record; the same way as selecting the OK & New action.
Alt+Shift+W	Open the current card or document in a new window. For more information, see Multitasking Across Multiple Pages.
Ctrl+Enter	Save and close the page.
Ctrl+Down Arrow	Open the next record for an entity.
Ctrl+Up Arrow	Open the previous record for an entity.
Ctrl+Insert	Insert a new line in documents.
Ctrl+Delete	Delete the line, in documents, journals, and worksheets.
Ctrl+Shift+F12	Maximize the line items part on a document page. Press the keys again to return to the normal display. For more information, see Focusing on Line Items.
F6	Move to the next FastTab or part (subpage).
Shift+F6	Move to previous FastTab or part (subpage).

Shortcut Key For Adding New Row In Excel Macos

Quick Entry Shortcuts for Fields

The following shortcuts pertain to the Quick Entry feature on cards, documents, and list pages. On lists, the shortcuts cannot be used when the list is in the tile view. For more information about Quick Entry, see Accelerating Data Entry Using Quick Entry.

Press these keys (in macOS)	To do this	Remarks
Enter	Confirm the value in the current field and go to the next Quick Entry field.
Shift+Enter	Confirm the value in the current field and go to the previous Quick Entry field.
Ctrl+Shift+Enter	Confirm the value in the current column and go to next Quick Entry field outside the list. This shortcut applies to embedded lists on a page, such as line items on a sales order. It enables you to quickly get out of the list and continue entering data in other fields on the page.

Keyboard Shortcuts in the Calendar (Date Picker)

Press these keys (in macOS)	To do this
Ctrl+Home	Open the calendar if closed. Note: This doesn't work if the date field is in a grid, where Ctrl+Home jumps to the first row.
Ctrl+Home (Cmd+Home)	Move to the current month, current day.
Ctrl+Left Arrow (Cmd+Left Arrow)	Move to the previous day.
Ctrl+Right Arrow (Cmd+Right Arrow)	Move to the next day.
Ctrl+Up Arrow (Cmd+Up Arrow)	Move to the previous week, same day of the week.
Ctrl+Down Arrow (Cmd+Down Arrow)	Move to the next week, same day of the week.
Enter	Select the focused date.
Ctrl+End (Cmd+End)	Close the calendar and delete the current date.
Esc	Close the calendar without a selection, keep the current date.
Page Down	Move to the next month.
Page Up	Move to the previous month.