Suppose you need to hide a small section of data in Excel, but you still want to calculate with it. Highlight the cells, right-click, and select Format Cells. Click the Number tab, and select the Custom category on the left. … Continue reading
To save a chart as a template: Create your chart, and then right click it. Select Save as Template… You’ll save a file with a CRTX extension in your default Microsoft Excel Templates folder. To create a new chart based … Continue reading
Right-Clicking in Google Drive You can now right-click on items in Google Drive to display a context-sensitive menu. Using the SHIFT and CTRL Keys in Google Drive You can now use the SHIFT key to select a group of items. … Continue reading
To set default text: Select the text you want to make the default for all documents. Click the Styles drop-down menu, and then select Normal text > Update ‘Normal text’ to match. This sets the current text style as normal. … Continue reading
To quickly “star” (or “unstar”) an item in Google Docs, press the “s” key on the keyboard. To view all starred items (favorites), click Starred in the left column of the Google Drive main screen.
To quickly view keyboard shortcuts in Google Docs, press CTRL + / (forward slash).
The best solution to this problem is to change an option in Word that sets up a DDE connection with Excel, and displays the zip code the way it is formatted in Excel, with all leading zeroes. (See Mail Merge … Continue reading
To quickly capitalize a word in any version of Microsoft Word, press SHIFT + F3 (top row of keyboard). Repeatedly tap the F3 key while holding down the SHIFT key to cycle through case options for the selected text — … Continue reading
The new Smart Alignment Guides in PowerPoint 2013 make it easy to align objects with precision. Simply click to drag an image or text near another image or text. Red dotted lines appear automatically showing when your objects are aligned … Continue reading