Creating a bulleted list in Excel isn’t as straightforward as it is in Word. There is no Bullets button on the ribbon in Excel. What if you want to add a bulleted list to a worksheet?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel What is the keyboard shortcut for increasing / decreasing the list level of a line of text / bullet? I only seem to be able to do this by clicking on the button in the Bullets & Numbering section of the Formatting Palette. Some of the easiest ways to get the most of out of Apple's desktop operating system are hidden in plain sight: Keyboard shortcuts. Flick between applications and tabs. Take screenshots. Fine tune settings. The most complete list of Mac keyboard shortcuts, keystrokes, tips, and tricks InDesign Scripts; Tips + Tricks Dan Rodney. Mac Keyboard Shortcuts Good, Concise Mac Keystrokes, Tips & Tricks. Keyboard Shortcuts; Multi-Touch Gestures. Delete Text to the right of the cursor (like the Del key on a full keyboard) Function(fn)-Delete. Configure your keyboard layout in Windows so that you can type all additional symbols you want as easy as any other text. Takes about 5-10 minutes to set things up, but you'll be typing like a boss. You can assign bullet point symbols • and any other text characters to your keyboard using this technique. To use a keyboard shortcut, press and hold one or more modifier keys and then press the last key of the shortcut. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys.
Today we’ll show seven ways to create a bulleted list in Excel.
1. Create a Bulleted List Using Keyboard Shortcuts
The simplest way to create a bulleted list is to use a keyboard shortcut35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & MacKeyboard shortcuts can save you a lot of time! Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac.Read More to enter a bullet character into a cell.
Select the cell you want to type a bullet in and press either Alt + 7 or Alt + 0149 for a solid bullet or Alt + 9 for a hollow bullet. When typing the numbers in these shortcuts, you must use the number pad on your keyboard.
If you’re using a laptop without a number pad, you may be able to turn on Num Lock to emulate a number pad. Not all laptops have the Num Lock key. If yours has one, it would probably be on one of the function keys. You can either press Shift + Num Lock or Fn + Num Lock. Then, the numbers for the “number pad” will be on some of the letter and number keys on the right side of the keyboard.
If you don’t have access to a number pad at all, don’t worry. The next section shows you how to enter bullets into cells without using the number pad.
2. Create a Bulleted List Using the Symbol Dialog Box
If you don’t have a physical or emulated number pad on your keyboard, or if you forget the keyboard shortcuts for bullets, you can use the Symbol dialog box.
On the Insert tab, go to Symbols > Symbol in the Symbols section. If your Excel window is big enough, you can click the Symbol button in the Symbols section directly, without clicking the Symbols button first.
The default font Calibri is automatically selected in the Font dropdown list, but you can select a different font.
Select the symbol you want to use for your bullets and click Insert. Then, click Close.
If you have difficulties finding a bullet icon among other symbols, we’ve provided some bullet symbols you might want to use in the image below. On the Symbol dialog box, first select Unicode (hex) from the from dropdown list. Then, type one of the codes shown in the image below into the Character code box.
Type one or two (or more) spaces after the bullet in the cell.
Then, copy and paste the bullets to the other cells and add your text.
To quickly populate other cells in the same column with bullets, enter a bullet in the first cell and then use the Fill Handle to automatically copy and paste the bullet into the other cells.
3. Create a Bulleted List Using a Custom Format
If you need to create a long bulleted list, you can use a custom number format to make it faster add bullets to your list items.
If you don’t have a number pad, first insert a bullet into a cell you’re not using and then copy it.
Select the cells you want to add bullets to. They can be empty or already have text. Then, right-click on the selected cells and select Format Cells, or press Ctrl + 1.
On the Number tab, select Custom under Category.
In the Type box, either paste the bullet you copied or use one of the keyboard shortcuts we showed you to type a bullet. Then, type a space or two (or more) and the @ character.
Click OK. The new type is automatically applied to the selected cells.
Now when you want to add bullets to cells, select the cells you want to add bullets to. Then, press Ctrl + 1 to open the Format Cells dialog box, select Custom under Category on the Number tab, and select the new Type you created.
4. Create a Bulleted List in a Single Cell
To enter a bulleted list into a single cell, double-click on the cell and use a keyboard shortcut or the Symbol dialog box to insert a bullet. Type the number of spaces you want and then the text you want for the first bullet point.
Press Alt + Enter to go to the next line in the cell. Then, enter another bullet, one or more spaces, and the text for your second bullet point.
Repeat for each bullet point, pressing Alt + Enter at the end of each line. Then, press Enter when you’re done creating the list.
5. Create a Bulleted List by Copying It From Word
If you created a bulleted list in Microsoft WordHow to Format and Manage Lists in Microsoft WordHow to Format and Manage Lists in Microsoft WordNo matter how many bulleted or numbered lists you have created with Microsoft Word in your life so far, I bet you will learn something new from this guide! Or did we miss something?Read More, or another word processor like LibreOffice Writer9 Effective LibreOffice Writer Tips to Boost Your Productivity9 Effective LibreOffice Writer Tips to Boost Your ProductivityThe one free Microsoft Office alternative that shines above the rest is LibreOffice. We'll help you get (more) familiar and productive with this versatile office suite.Read More, that you want to add to your spreadsheet, select the list in that program and press Ctrl + C to copy it.
To insert the entire list into a single cell, double-click the cell, and press Ctrl + V. There may not be any spaces between the bullets and the text on each line, but you can fix that by putting the cursor where you want and adding spaces.
To insert each item in the list into separate cells, select the cell where you want to insert the first item and press Ctrl + V.
You may have to adjust the spacing in each cell.
6. Create a Bulleted List Using a Function
To add bullets to multiple cells at a time, you can also use a functionTips for Working With Text and Text Functions in ExcelTips for Working With Text and Text Functions in ExcelLet's look at various ways of working with text in Excel spreadsheets. Learn several different Excel text functions and see how they can save you time.Read More. The CHAR function takes a character code and displays the character that corresponds to that code in the cell. We’re going to work with codes in Windows. (Character codes on a Mac will differ but the use of the CHAR function is the same.)
To enter a solid bullet character in multiple cells in Excel for Windows, select the cells and click in the Formula bar. Type the following function and press Ctrl + Enter:
All the selected cells are populated with the solid bullet character.
When using this method, you’ll have to put the text for each bulleted item in the column to the right of the bullets, like we did in the image below.
You can build a bulleted list in one column using the CHAR function in a formula. This method is useful if you already have a list of items in another column without bullets.
Select the cell to contain the first item with the bullet character. Then, enter the following formula, replacing “C3” with the cell reference for the first item in the other column.
This formula concatenates a solid bullet character, one space, and the value of the referenced cell (C3 in our case). You can enter more than one space between the quotes if you want.
To copy the formula to the rest of the cells where you want the list, select the cell where you just entered the formula. Then, drag the AutoFill box in the lower-right corner of the cell down over the cells you want to fill.
When you release the mouse button, the formula is copied to those cells with the appropriate cell references for each row.
With the formulas, you cannot delete the items from the other column, because they’re still being referenced in the formulas. But we’ll solve that by converting the formulas to values.
To convert the formulas to values, select the cells containing the formulas and press Ctrl + C to copy them.
![Mac keyboard shortcuts for right click Mac keyboard shortcuts for right click](/uploads/1/2/6/1/126126431/369874788.png)
Click the bottom half of the Paste button in the Clipboard section of the Home tab. Then, click the first button under Paste Values.
Excel replaces the formulas in the cells with the concatenated values.
7. Create a Bulleted List Using Special Fonts
Windows comes with some special fonts that are just symbols, like Wingdings and Webdings. Wingdings has some symbols that make some nice bullets.
To insert a bullet character into cells using a symbols font, first select the cells. Then, in the Font section on the Home tab, change the font to Wingdings.
Select the first cell you want to enter a bullet into and type a lowercase “L” (l) to enter a large solid bullet, a “w” to enter a small solid bullet, or one of the other letters shown in the following image to enter other styles of bullets. Do the same for the other cells you changed to the Wingdings font.
To use this method, you must put the bullet characters in their own cells in the column to the left of the items in your list because of the symbol font you’re using on the cells with the bullets. Then, change the width of the column containing the bullets to the width of the bullets.
You can choose from more bullet symbols using the CHAR function with the Wingdings font. The image below shows the CHAR function values for various kinds of bullet characters.
When using the CHAR function with the Wingdings font, you must enter the CHAR function first in a non-symbol font and then change the font of the cell(s) to Wingdings.
That’s all! You can also create other types of lists in Excel3 Types of Excel Lists to Ease Data Entry3 Types of Excel Lists to Ease Data EntryNeed a list based on spreadsheet data? Here's how to add custom, dropdown, and checklists to your worksheets and free Excel list templates you can download.Read More to make data entry easier.
Explore more about: Microsoft Excel, Microsoft Office Tips.
You can use keyboard shortcuts to quickly accomplish many tasks in Pages. To use a keyboard shortcut, press all the keys in the shortcut at the same time.
Mac Word Keyboard Shortcuts
General
Action | Shortcut |
---|---|
Start dictation | Press Fn twice |
Open the template chooser | Command-N |
Open the template chooser and show the Language pop-up menu | Option-Command-N |
Close the template chooser | Esc |
Open an existing document | Command-O |
Save a document | Command-S |
Save As | Option-Shift-Command-S |
Duplicate a document | Shift-Command-S |
Print a document | Command-P |
Open the Pages User Guide | Shift-Command-Question Mark (?) |
Close a window | Command-W |
Close all windows | Option-Command-W |
Minimize a window | Command-M |
Minimize all windows | Option-Command-M |
Enter full-screen view | Control-Command-F |
Zoom in | Command-Right Angle Bracket (>) |
Zoom out | Command-Left Angle Bracket (<) |
Zoom to selection | Shift-Command-0 |
Return to actual size | Command-0 |
Show or hide the tab bar | Shift-Command-T |
Show page thumbnails | Option-Command-P |
Show or hide the ruler | Command-R |
Open the Page Setup window | Shift-Command-P |
Show or hide layout boundaries | Shift-Command-L |
Show formatting characters (invisibles) | Shift-Command-I |
Choose a file to insert | Shift-Command-V |
Show the Colors window | Shift-Command-C |
Hide or show the toolbar | Option-Command-T |
Rearrange an item in the toolbar | Command-drag |
Remove an item from the toolbar | Command-drag away from the toolbar |
Hide or show sidebars on the right side of the Pages window | Option-Command-I |
Open the next tab in the sidebar | Control-Accent Grave (`) |
Open the previous tab in the sidebar | Shift-Control-Accent Grave (`) |
Hide Pages | Command-H |
Hide windows of other applications | Option-Command-H |
Undo the last action | Command-Z |
Redo the last action | Shift-Command-Z |
Open Pages preferences | Command-comma (,) |
Quit Pages | Command-Q |
Quit Pages and keep windows open | Option-Command-Q |
Move around within a document
Action | Shortcut |
---|---|
Move one character to the left | Left Arrow |
Move one character to the right | Right Arrow |
Move one character backward (works for left-to-right and right-to-left text) | Control-B |
Move one character forward (works for left-to-right and right-to-left text) | Control-F |
Move to the line above | Up Arrow |
Move to the line below | Down Arrow |
Move to the beginning of the current or previous word | Control-Option-B |
Move to the left edge of the current word (works for left-to-right and right-to-left text) | Option-Left Arrow |
Move to the end of the current or next word | Control-Option-F |
Move to the right edge of the current word (works for left-to-right and right-to-left text) | Option-Right Arrow |
Move the insertion point to the beginning of the current text area (document, text box, shape, or table cell) | Command-Up Arrow |
Move the insertion point to the bottom of the current text area (document, text box, shape, or table cell) | Command-Down Arrow |
Move to the beginning of the paragraph | Control-A or Option-Up Arrow |
Best free text to speech for mac. Move to the end of the paragraph | Control-E or Option-Down Arrow |
Move to the left edge of the current line | Command-Left Arrow |
Move to the right edge of the current line | Command-Right Arrow |
Scroll up one page without moving the insertion point | Fn-Up Arrow or Page Up |
Scroll down one page without moving the insertion point | Fn-Down Arrow or Page Down |
Scroll up one page and move the insertion point | Option-Page Up |
Scroll down one page and move the insertion point | Control-V or Option-Page Down |
Move to the beginning of the document without moving the insertion point | Home or Fn-Left Arrow |
Move to the end of the document without moving the insertion point | End or Fn-Right Arrow |
Center the insertion point in the center of the application window | Control-L |
Select text
![Mac Keyboard Shortcuts For Text Bullet Mac Keyboard Shortcuts For Text Bullet](/uploads/1/2/6/1/126126431/329176222.png)
Action | Shortcut |
---|---|
Select one or more characters | Click in front of the first character and drag across the characters you want to select |
Select a word | Double-click the word |
Select a paragraph | Triple-click in the paragraph |
Select all objects and text | Command-A |
Deselect all objects and text | Shift-Command-A |
Extend the text selection | Click in the text, then Shift-click in another location in the text |
Extend the selection one character to the right | Shift-Right Arrow |
Extend the selection one character to the left | |
Extend the selection to the end of the current word, then to the end of subsequent words | Option-Shift-Right Arrow |
Extend the selection to the beginning of the current word | Option-Shift-Left Arrow |
Extend the selection to the end of the current line | Shift-Command-Right Arrow |
Extend the selection to the beginning of the current line | Shift-Command-Left Arrow |
Extend the selection to the line above | Shift-Up Arrow |
Extend the selection to the line below | Shift-Down Arrow |
Extend the selection to the beginning of the current paragraph | Option-Shift-Up Arrow |
Extend the selection to the end of the current paragraph | Option-Shift-Down Arrow |
Extend the selection to the beginning of the text | Shift-Command-Up Arrow or Shift-Home |
Extend the selection to the end of the text | Shift-Command-Down Arrow or Shift-End |
Select a bullet and its text | Click the bullet |
Move a bullet and its text, with its sub-bullets and text | Click the bullet and drag |
Format text
Action | Shortcut |
---|---|
Show the Fonts window | Command-T |
Show the Colors window | Shift-Command-C |
Apply boldface to selected text | Command-B |
Apply italic to selected text | Command-I |
Apply underline to selected text | Command-U |
Delete the previous character or selection | Delete or Control-H |
Delete the next character or selection | Control-D or Forward Delete (not available on all keyboards) |
Delete the word before the insertion point | Option-Delete |
Delete the word after the insertion point | Option-Forward Delete (not available on all keyboards) |
Delete the text between the insertion point and the next paragraph break | Control-K |
Make the font size bigger | Command-Plus Sign (+) |
Make the font size smaller | Command-Minus Sign (-) |
Decrease (tighten) the space between selected characters | Option-Command-Left Bracket ([) |
Increase (loosen) the space between selected characters | Option-Command-Right Bracket (]) |
Make the text superscript | Control-Shift-Command-Plus Sign (+) |
Make the text subscript | Control-Command-Minus Sign (-) |
Insert an equation | Option-Command-E |
Align the text flush left | Command-Left Brace ({) |
Center the text | Command-Vertical Bar (|) |
Align the text flush right | Command-Right Brace (}) |
Align the text flush left and flush right (justify) | Option-Command-Vertical Bar (|) |
Decrease the indent level of a block of text or a list item | Command-Left Bracket ([) |
Increase the indent level of a block of text or a list item | Command-Right Bracket (]) |
Decrease the indent level of a list item | Shift-Tab |
Increase the indent level of a list item | Tab |
Turn text into a link | Command-K |
Add a bookmark | Option-Command-B |
Cut the selection | Command-X |
Copy the selection | Command-C |
Copy the paragraph style | Option-Command-C |
Paste the selection | Command-V |
Paste the paragraph style | Option-Command-V |
Paste and match the style of the destination text | Option-Shift-Command-V |
Copy the graphic style of text | Option-Command-C |
Paste the graphic style of text | Option-Command-V |
Add a range to (or remove it from) the selection | Shift-drag |
Insert a nonbreaking space | Option-Space bar |
Insert a line break (soft return) | Shift-Return |
Insert a paragraph break | Return |
Insert a new line after the insertion point | Control-O |
Insert a page break | Fn-Command-Return |
Enter special characters | Control-Command-Space bar |
Transpose the characters on either side of the insertion point | Control-T |
Add an EndNote bibliography | Shift-Option-Command-E |
Apply a paragraph, character, or list style using your own shortcut |
Find and delete text, use comments, and check spelling
Action | Shortcut |
---|---|
Delete the previous character or selection | Delete |
Delete the next character or selection | Fn-Delete or Forward Delete (not available on all keyboards) |
Find | Command-F |
Find next (while in the Find window) | Command-G |
Find previous (while in the Find window) | Shift-Command-G |
Place the selected text in the Find & Replace text field | Command-E |
Replace text | Return |
Scroll the window to show the selected text or object | Command-J |
Hide the Find window | Esc |
Look up the word at the insertion point | Control-Command-D |
Display a list of words to complete the selected word | Option-Esc |
Check spelling and grammar | Command-Semicolon (;) |
Show the “Spelling and Grammar” window | Shift-Command-Colon (:) |
Highlight text | Shift-Command-H |
Open a new comment for the selected text, object, or table cell | Text edit. Shift-Command-K |
Save a comment | Command-Return |
Show the next comment | Option-Command-K |
Show the previous comment | Option-Shift-Command-K |
Accept a change (when change tracking is on) | Option-Command-A |
Reject a change (when change tracking is on) | Option-Command-R |
Show or hide word count | Shift-Command-W |
Enter or exit edit master page view | Shift-Command-E |
Move, group, layer, and resize objects
Action | Shortcut |
---|---|
Select all objects | Command-A |
Deselect all objects | Shift-Command-A |
Select objects by dragging | In page layout documents, drag from a blank part of the page around objects. Option-drag to select objects outward from the starting point. |
Scroll zoom | For Magic Mouse or a trackpad: Option-Command-scroll |
Add or remove objects from the selection | Wrap text excel for mac. Command-drag |
Select the previous object on the page | Shift-Tab |
Select or deselect additional objects | Command-click or Shift-click |
Move selected objects | Drag |
Move the selected object one point | Press an arrow key |
Move the selected object ten points | Press Shift and an arrow key |
Move the selected object one screen pixel | Press an arrow key |
Move the selected object ten screen pixels | Press Shift and an arrow key |
Copy the graphic style | Option-Command-C |
Paste the graphic style | Option-Command-V |
Apply the shape style but not its text style | Option-click the shape style in the sidebar on the right side of the Pages window |
Send the selected object to the back | Shift-Command-B |
Send the selected object one layer back | Option-Shift-Command-B |
Bring the selected object to the front | Shift-Command-F |
Bring the selected object one layer forward | Option-Shift-Command-F |
Group selected objects | Option-Command-G |
Ungroup selected objects | Option-Shift-Command-G |
Select an object in a group | Double-click the object |
Select the next object in a group | Tab |
Select the previous object in a group | Shift-Tab |
End editing an object, then select the group | Select an object in the group, then press Command-Return |
Lock selected objects | Command-L |
Unlock selected objects | Option-Command-L |
Duplicate the object | Option-arrow key or Option-drag |
Constrain the movement of the object horizontally, vertically, or diagonally (45°) | Shift-drag |
Resize the object | Drag a selection handle |
Disable alignment guides while moving or resizing an object | Command-drag |
Resize the object from the center | Option-drag a selection handle |
Constrain the aspect ratio when resizing the object | Shift-drag a selection handle |
Constrain the aspect ratio when resizing the object from the center | Option-Shift-drag a selection handle |
Rotate the object | Command-drag a selection handle |
Rotate the object 45° | Press Shift while rotating |
Rotate the object around the opposite handle (instead of the center) | Option-Command-drag a selection handle |
Rotate the object 45° around the opposite handle (instead of the center) | Option-Shift-Command-drag a selection handle |
Mask or unmask the image | Shift-Command-M |
Hide image mask controls | Return, Enter, or double-click |
Show image mask controls | Double-click the masked image |
Open the shortcut menu for the selected item | Control-click the item |
Exit text editing and select the object | Command-Return |
Choose an object to insert | Shift-Command-V |
Define the selected text as a text placeholder | Control-Option-Command-T |
Define the image or movie as a media placeholder | Control-Option-Command-I |
Modify editable shapes
Action | Shortcut |
---|---|
Make a custom shape editable | Double-click the edge of the shape |
Draw a custom shape with the Pen tool | Option-Shift-Command-P |
Move a point of an editable shape | Drag the point to another location |
Delete a point of an editable shape | Click the point, then press Delete on your keyboard |
Add a sharp point to an editable shape | Command-drag the midpoint of a line |
Add a smooth point to an editable shape | Drag the midpoint of a line |
Add a Bézier point to an editable shape | Option-drag the midpoint of a line |
Change a curve point of an editable shape into a corner point | Double-click the curved point |
Reshape the curve of a smooth point | Drag the line adjacent to the smooth point |
Reshape the curve of a Bézier point | Click a Bézier point and drag the control |
Work with tables
Mac Keyboard Shortcuts For Symbols
Action | Shortcut |
---|---|
Add a row above the selected cells | Option-Up Arrow |
Add a row below the selected cells | Option-Down Arrow |
Add a column to the right of the selected cells | Option-Right Arrow |
Add a column to the left of the selected cells | Option-Left Arrow |
Insert a row at the bottom of the table | Option-Return |
Select an entire row or column | Click the table, then click the letter for the column or the number for the row |
Select additional rows | Shift-Up Arrow or Shift-Down Arrow |
Select additional columns | Shift-Right Arrow or Shift-Left Arrow |
Select additional cells | Shift-click |
Select only body cells in a row or column | Double-click the letter for the column or the number for the row |
Move the cell selection to the beginning of the next row | Select a cell in the rightmost column, then press Tab |
Stop the reordering of rows or columns | Press Esc while dragging |
Select a table from a cell selection | Command-Return |
Select all content in a table | Select a cell, then press Command-A |
Delete the selected table, or the contents of selected cells | Delete |
Replace the contents of the selected cell with the contents of the destination cell | Press a cell, then drag it to another cell |
Copy the contents of the selected cell into the destination cell | Press a cell, then Option-drag it to another cell |
Copy cell style | Option-Command-C |
Paste cell style | Option-Command-V |
Paste and preserve the style of the destination cell | Option-Shift-Command-V |
Extend the selection from the selected cell to the destination cell | Shift-click in the destination cell |
Select a cell | Click a cell in a selected table (double-click a cell in an unselected table) |
Add a cell to (or remove it from) the selection | Command-click a selected or unselected cell |
Begin text editing | Return or Enter (in a selected cell) |
Auto-align cell content | Option-Command-U |
Stop editing the cell and select the cell | Command-Return |
Stop editing the cell and select the table | Command-Return twice |
Move the selected table one point | Press an arrow key |
Move the selected table ten points | Press Shift and an arrow key |
Constrain the movement of the table horizontally, vertically, or diagonally (45°) | Shift-drag the table |
Resize all columns in a table proportionately | Select the table, then Shift-drag a resize handle |
Select the next cell to the left, right, up, or down | Press an arrow key (from a selected cell) |
Extend the cell selection by one cell | Press Shift and an arrow key (from a selected cell) |
Select the next cell | Tab |
Select the previous cell | Shift-Tab |
Insert a tab when editing text or a formula | Option-Tab |
Insert a line break (soft return) when editing text in a cell | Control-Return |
Insert a paragraph break (hard return) when editing text in a cell | Return |
Open the formula editor for the selected nonformula cell | Equal Sign (=) |
Open the formula editor for the cell containing a formula or formatted number | Double-click |
In the formula editor, commit changes | Return or Tab |
In the formula editor, discard changes | Esc |
Edit chart data
Action | Shortcut |
---|---|
Show or hide the Chart Data editor | Shift-Command-D |
Complete a cell entry and move the selection down | Return |
Complete a cell entry and move the selection up | Shift-Return |
Complete a cell entry and move the selection to the right | Tab |
Complete a cell entry and move the selection to the left | Shift-Tab |
Move one character to the left or right | Press the Left Arrow or Right Arrow key |
Move to the beginning of text or to the end of text | Press the Up Arrow or Down Arrow key |
Move the chart legend one point | Select the legend, then press an arrow key |
Move the chart legend ten points | Select the legend, then hold down Shift and press an arrow key |
Create cell references in formulas
Action | Shortcut |
---|---|
Navigate to and select a single cell | Press Option and an arrow key |
Extend or shrink a selected cell reference | Press Option-Shift and an arrow key |
Navigate to and select the first or last cell in a row or column | Press Option-Command and an arrow key |
Change a selected cell reference back to text | Select a reference and press Option-Return |
Specify absolute and relative attributes of selected cell references | Press Command-K or Shift-Command-K to move forward or backward through options |
Specify absolute and relative attributes of the first and last cells of selected cell references | Press Option-Command-K or Option-Shift-Command-K to move forward or backward through options |