Scroll to display the active cell. Access search when in a cell or when a cell is selected. Move between unlocked cells on a protected sheet. Edit the selected cell. Complete a cell entry and move forward in the selection.
- fast way to delete photos on mac;
- Mac Excel Keyboard Shortcuts – cugitigazisu.cf?
- The Excel Skinny.
- In this topic;
Start a new line in the same cell. Fill the selected cell range with the text that you type. Complete a cell entry and move up in the selection. Complete a cell entry and move to the right in the selection. Complete a cell entry and move to the left in the selection. Cancel a cell entry. Delete the character to the left of the insertion point, or delete the selection.
MS Excel for Mac: Draw a border around a cell
Delete the character to the right of the insertion point, or delete the selection Note: Some smaller keyboards do not have this key. Delete text to the end of the line Note: Some smaller keyboards do not have this key. Move one character up, down, left, or right. Move to the beginning of the line. Insert a comment.
Open and edit a cell comment. Fill down. Fill to the right. Define a name. Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents. Complete a cell entry. Enter a formula as an array formula. Cancel an entry in the cell or formula bar.
Display the Formula Builder after you type a valid function name in a formula. Insert a hyperlink. Edit the active cell and position the insertion point at the end of the line. Open the Formula Builder. Calculate the active sheet. Display a contextual menu. Start a formula. Toggle the formula reference style between absolute, relative, and mixed. Insert the AutoSum formula. Enter the date.
Enter the time. Copy the value from the cell above the active cell into the cell or the formula bar. Alternate between displaying cell values and displaying cell formulas. Copy a formula from the cell above the active cell into the cell or the formula bar. Display the AutoComplete list. Create a table. Insert a line break in a cell. Insert special characters like symbols, including emoji. Increase font size.
Decrease font size. Align center. Align left. Apply the general number format. Apply the currency format with two decimal places negative numbers appear in red with parentheses. Apply the percentage format with no decimal places. Apply the exponential number format with two decimal places. Apply the date format with the day, month, and year. Apply the time format with the hour and minute, and indicate AM or PM.
Apply the number format with two decimal places, thousands separator, and minus sign - for negative values. Apply the outline border around the selected cells. Add an outline border to the right of the selection. Add an outline border to the left of the selection. Add an outline border to the top of the selection. Add an outline border to the bottom of the selection.
Remove outline borders. Apply or remove bold formatting. Apply or remove italic formatting. Apply or remove underscoring. Apply or remove strikethrough formatting. Hide a column. Unhide a column. Hide a row. Unhide a row. Edit the active cell. Cancel an entry in the cell or the formula bar.
Paste text into the active cell. Give selected cells the current cell's entry. Extend the selection by one cell. Extend the selection to the last nonblank cell in the same column or row as the active cell. Extend the selection to the beginning of the row. Extend the selection to the beginning of the sheet. Extend the selection to the last cell used on the sheet lower-right corner. Select the entire column. Select the entire row. Select the entire sheet. Select only visible cells. Select only the active cell when multiple cells are selected.
Extend the selection down one screen. Extend the selection up one screen. Alternate between hiding objects, displaying objects, and displaying placeholders for objects. Turn on the capability to extend a selection by using the arrow keys. Add another range of cells to the selection. Select the current array, which is the array that the active cell belongs to. Select cells in a row that don't match the value in the active cell in that row.
You must select the row starting with the active cell. Select only cells that are directly referred to by formulas in the selection. Select all cells that are directly or indirectly referred to by formulas in the selection.
Table of contents
Select only cells with formulas that refer directly to the active cell. Select all cells with formulas that refer directly or indirectly to the active cell. Borders are formatting features used to improve the appearance of your worksheet. Borders make it easier to find and read specific data. Borders also draw attention to important data, such as the results of formulas. If you prefer to work with your keyboard, use a keyboard shortcut to add a border to the outside edges of one or more selected cells.
This shortcut uses the default line color and thickness.
The key combination to add a border is:. The Borders option is located under the Home tab and can be used to add custom borders to cells in your worksheet. When you're ready to add and format lines and borders in an Excel worksheet, you have several options:. The Draw Border feature is located at the bottom of the Borders drop-down menu.
One advantage of using Draw Border is that it is not necessary to select cells first. Draw Border also contains options for changing the line color and line style.
The 100+ Excel 2016 Shortcuts You Need to Know, Updated for Windows and Mac
The line style options allow you to create borders with:. From this list, you can choose a different line color, change the line thickness, and draw border lines around cells. Select Line Style and choose the line thickness you want to apply to the border. Another option on in the Borders list is Draw Border Grid. With Draw Border Grid, you can add outside and inside borders to one or more cells at the same time. Excel remembers the last type of border you use, so selecting Borders again re-enables that mode.
The Erase Border option, as the name suggests, makes it easy to remove borders from worksheet cells. Erase Border allows you to remove border lines individually by selecting them. You can remove multiple borders by dragging across those cells.
- best video app for mac;
- Save an hour of work a day with these 5 advanced Excel tricks.
- Download 200+ Excel Shortcuts;
- how to restore your mac air to factory settings!
- Excel keyboard shortcuts for Windows and Mac | Office Hack.
Share Pin Email. To add a border to a range of cells within an Excel worksheet:. Press and hold the Ctrl and the Shift keys.