Revert to Auto Leading, Cmd-Option-Shift-A. In Word 2010 or a later version, display the File tab of the ribbon and then click Options.) Click Display at the left side of the dialog box.(add Cmd to the above keystrokes to make them Increment x 5). (In Word 2007 click the Office button and then click Word Options. To turn off the display of hidden text on the screen, follow these steps: Display the Word Options dialog box.The following sequence will result in strikethrough being applied to any text There are two Alt keys on a Mac keyboard. Ctrl + B applies bold formatting, Ctrl + I will italicize text, and Ctrl + U adds an underline. Many font attributes can be applied using standard keyboard shortcuts.
Open a Word document and on the Mac menu, not the menu in Word - choose Tools> Customize Keyboard. If you use Word regularly, you should do this simple task. Microsoft Word allows users to update shortcuts, unlike the Office 2016 applications. At that point, you'll need to chose the type of paste you want to perform.Create or delete custom shortcuts in Word. Just use the key that is easier to reach for the keyboard shortcut you are performing.This shortcut, Control + Alt + V (Mac: Control + Command + V) doesn't actually finish the paste it just opens the Paste Special dialog box. Note that they have the same function. But did you know that you can also paste formatting, paste column widths, multiply and add values in place, and even transpose tables? It's all there. At the very least, you probably already use paste special to strip out unwanted formatting and formulas (Paste special > Values). Opens a new window in incognito mode.There are so many things you can do with paste special it's a topic in itself. Chrome Tab and window shortcuts. This is far faster than fiddling with each filter manually. So, if you have a multiple filters active, you can "reset" all filters by using the shortcut twice in a row: once to remove the filters (which clears all filters), and once again to add a new autofilter. But the best part is toggling off the autofilter will clear any filters that have been set. With the same shortcut, Control + Shift + L (Mac: Command + Shift + F) you can toggle filters on and off any list or data set. ![]() The cursor will travel to the first empty cell (or the edge of the spreadsheet, whichever comes first). Rather than scroll up, down, right and left, manually just put your cursor into the data and use Control + Arrow key to move in any direction to the edge of the data range (On a Mac you can use Command or Control). Move to edge of data regionThis shortcut sounds boring but it is vital if you routinely work with big lists or tables. Finally, the third time you use Control + A, the entire worksheet is selected. The second time, both the table data + table header are selected. You're never going to beat it scrolling. If we figure there are about 6 rows in an inch, then:1,048,576 rows / 6 = 174,763 inches / 12 = 14,564 feet / 5280 = 2.76 miles2.76 miles in 1 second * 60 = 165.6 miles per minute * 60 = 9,936 miles per hour.Since it really takes less than a second to travel more than 1 million rows, let's just call it 10,000 miles per hour. If you put your cursor in A1 and press Control + down arrow, you'll be past the millionth row in less than a second. Even though the cursor is moving at great speed, it will stop on a dime at the edge of a data region.Select right = Shift + Control + Right arrowSelect left = Shift + Control + Left arrowSelect down = Shift + Control + Down arrow Move to first cell in worksheetNavigating larger worksheets can get really tedious. The best part about using Shift + Control + Arrow is that your selections are perfectly accurate. A really long time.To save your sanity and avoid all that scrolling, just add the Shift key to the Control + Arrow shortcut, and you will *extend* the current selection to include all the cells along the way. Because when you try to select large collections of cells manually (let's say 10,000 rows), you will be scrolling a long time. What is the last cell? Good question. Move to last cell in worksheetIn a similar way, you can jump to the "last cell" in a worksheet using Control + End (Mac: Fn + Control + Right arrow). This will bring you straight back to cell A1, no matter how far you've wandered. If you just want to get back to the first screen in a worksheet, use the keyboard shortcut Control + Home (Mac: Fn + Control + left arrow). This is a nice way to step through matches in a worksheet methodically.By the way: to activate Find, use Control + F (Mac: Command + F). Find next matchRather basic, but worth knowing: once you've set up a find, and have found at least one match, you can keep finding "the next match" by using Shift F4 (Mac: Command + G). In this case, it's likely that there's extra data somewhere in the worksheet. It's also useful when you notice that a workbook is suddenly a lot bigger on disk that it should be. You can use this to make sure you don't accidentally print 16 blank pages because there's stray data in cell BF1345, for some unknown reason. Often, the last cell in a worksheet doesn't contain any data itself - it just defines the lower right edge of a rectangle that makes up the used portion of the worksheet.One good use of this shortcut is to quickly see if there is any other data in the worksheet that you're not aware of. To select a row, use Shift + Space. Select row / select columnBoth rows and columns can be selected with keyboard shortcuts. On Windows, this will open the find and replace dialog with with Replace selected. Just select the first cell (or cells) then hold down the control or command key and click other cells to add them to your selection. This is easily done using Control + Click (Mac: Command + Click). You might want to enter the same data to several cells (see Control + Enter) change formatting, or even use the status bar to get an on-the-fly SUM for a group of random cells. Add non-adjacent cells to selectionYou'll often need to select cells that aren't next to one another. You can then hold the shift key down and use the Up or Down arrow keys to select additional rows above or below row 10.Note that if you are working in an Excel table, these same shortcuts will select rows and columns within the table, not the entire worksheet.Also note that once you have rows or columns selected, you can use other keyboard shortcuts to insert, delete, hide, and unhide. For example, if the cursor is in row 10 and you press Shift + Space, row 10 will be selected. From there, you need to click the Special button to get all the way to Go To Special. Did you know you can use Go To Special to select only formulas? Only constants? Only blank cells? You can do all that and a lot more.Unfortunately, the shortcut Control + G (both platforms) only gets you half way, to the Go To dialog box. Display 'Go To' dialog boxThe Go To Special dialog is a bit like the Paste Special Dialog - within lies a treasure trove of utility hidden in an innocuous sounding control. But you can also just use Control + Backspace (Mac: Command + Delete) to automatically scroll the cursor into view, nicely centered in the window. You could press an arrow keys to bring the cursor into view (and move to a new cell at the same time) or you could consult the namebox to get the address. Get infinite photoshop for free macEnter the same value in multiple cellsThis shortcut may not seem interesting, but you'll be surprised how often you use it once you understand how it works. Here is the answer revealed: Alt + Enter (Mac: Control + Option + Return) will add a new line inside a cell. This is often a puzzle to Excel users (for obvious reasons) and I have no doubt that this puzzle has resulted in hundreds of thousands, if not millions, of Google searches. Office Keyboard Shortcut Apply Hidden Text Serial Number FormatInsert current date / Insert current timeNo Excel shortcut guide would be complete without mentioning these stalwarts for entering the current date and time.To enter the current date, use Control + To enter the current time, use Control + Shift + :If you want to enter both the current date and time, type control + , then enter a space, followed by Control + Shift + :With either shortcut, excel will enter the current date or time using a valid Excel date in serial number format, with dates as integers and times as decimal values. (See the previous shortcut for selecting non-adjacent cells.)Control-enter also has another use: use it when you want to enter a value into a cell and stay in that same cell after hitting return. You can even use Control + Enter to enter data into non-contiguous cells. This is a great way to save keystrokes when you want to enter the same value or formula in a group of cells.
0 Comments
Leave a Reply. |
AuthorJennifer ArchivesCategories |