Microsoft Word and Excel Bits & Bytes

Quickly insert hyperlinks into Microsoft Word and Excel

Quickly create hyperlinks in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".

Close all open files at once in Microsoft Word and Excel

Close all open Microsoft Word and Excel files by holding down the shift key and clicking "File" and then "Close All".

Quickly open recent files in Microsoft Word and Excel

Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4 or the number that corresponds in front of the recent document you wish to open

Print only sections of a page

Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Excel, Internet Explorer (and other browser), WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click the Print icon or option in the File menu. In the printer dialog window (like the one shown below) under Page Range choose the option Selection.

Quickly create tables in Microsoft Word

Microsoft Word is an incredibly powerful program, but getting at that power may not be as easy or intuitive as you might like. It can be incredibly frustrating when you know you should be able to do something with the program but can't, for the life of you, figure out how to do it.

WordTips is designed to help you figure out how to do the things you need to do with Microsoft Word, right now! Here you can find answers to your Microsoft Word questions, and those answers are free! This site contains thousands of tips, tricks, and ideas on how to use Microsoft Word better, faster, and more easily.
In particular, this site is most helpful for users of the menu-based Word interface. That means that the vast majority of tips on this site are for users of Word 97, Word 2000, Word 2002, and Word 2003. If you are using a newer version of Microsoft Word, you'll want to check out our sister site, which focuses on the ribbon-based Word interface introduced in Word 2007.
 Create tables in Microsoft Word by typing a plus (+) to start the table and tab until you want the table cell or table to end. For example, in the below example we have three + symbols separated by a single tab that would create a table similar to the table shown below them after pressing the enter key.

+         +         +

Formatting Spreadsheets using AutoFormat

Spreadsheets usually contain a lot of data. This can make it difficult, if not impossible for users to find the information they are looking for. Formatting a spreadsheet effectively can change that. A good choice of background color, font style and font size, plus other formatting options can make the most important information on the spreadsheet stand out from the rest of the data.
If you are new to Excel, and not yet comfortable with all the formatting options available, you can use the AutoFormat option to give your spreadsheets a professional look and make them easy to read.
There are 17 AutoFormat styles available. These styles affect six main formatting areas: number formatting, borders, fonts, patterns and background color, alignment, and column and row size. 

Choose an Appropriate Style
 
Not all the styles are appropriate for all spreadsheets. Keep in mind how the spreadsheet will be used when selecting an AutoFormat style:

• Printed off and given to the audience as a hand out.
  
• Used solely in a slide show presentation.
  
• Emailed to just a few associates.

Some of the styles are very "graphic intensive" and would not print well, and some are just not appropriate for business reports. Be sure to choose a style in keeping with your subject and your audience. If none of the styles are quite to your liking, you can modify them either before or after they have been applied to your worksheet. To modify a style before applying it, click on the options button in the AutoFormat dialog box. Doing so, will allow you to deselect any of the six formatting areas such as font, borders, or alignment before applying the style. The spreadsheet example in the dialog box will show you what the style will look like with the different options deselected. 

Fine-Tune Your Style Choice
 
Once you have applied a style you can modify it further using Excel’s regular formatting options located under the Format menu and on the formatting toolbar. Many people use the AutoFormat options as a starting point and then use the regular formatting options to fine-tune their selection so that it meets their needs exactly. 

To apply an AutoFormat style to your worksheet

1. Select only the data on the worksheet that you want formatted.
2. Choose Format > AutoFormat from the menus to bring up the AutoFormat dialog box.
3. Scroll through the list of styles.
4. Click on the one you want to use.
5. Click OK.

Mozilla Firefox Shorcuts

Mozilla Firefox shortcut keys

Below is a listing of all the major shortcut keys in Mozilla Firefox. See the computer shortcut page if you are looking for other shortcut keys used in other programs.

Shortcut Keys	Description
Alt + Home	Open your home page.
Alt + Left Arrow	Back a page.
Alt + Right Arrow	Forward a page.
F5	Refresh current page, frame, or tab.
F11	Display the current website in full screen mode. Pressing F11 again will exit this mode.
Esc	Stop page or download from loading.
Ctrl + (- or +)	Increase or decrease the font size, pressing '-' will decrease and '+' will increase. Ctrl + 0 will reset back to default.
Ctrl + Enter	Quickly complete an address. For example, type computerhope in the address bar and press CTRL + ENTER to get http://www.computerhope.com.
Ctrl + Shift + Del	Open the Clear Data window to quickly clear private data.
Ctrl + D	Add a bookmark for the page currently opened.
Ctrl + I	Display available bookmarks.
Ctrl + J	Display the download window.
Ctrl + K or Ctrl + E	Move the cursor to the search box.
Ctrl + N	Open New browser window.
Ctrl + P	Print current page or frame.
Ctrl + T	Opens a new tab.
Ctrl + F4 or Ctrl + W	Closes the currently selected tab.
Ctrl + Shift + T	Undo the close of a window.
Ctrl + Tab	Moves through each of the open tabs.
Spacebar	Moves down a page at a time.
Shift + Spacebar	Moves up a page at a time.
Alt + Down arrow	Display all previous text entered in a text box and available options on drop down menu.

General Keyboard shortcuts - Windows

The General Shortcuts

We’ll kickoff the list with some really general shortcuts that you often used.

• CTRL+C (Copy)
• CTRL+X (Cut)
• CTRL+V (Paste)
• CTRL+Z (Undo)
• Delete (Delete)
• Shift+Delete (Delete the selected item permanently without placing the item in the Recycle Bin)
• CTRL while dragging an item (Copy the selected item)
• CTRL+Shift while dragging an item (Create a shortcut to the selected item)
• F2 key (Rename the selected item)
• CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
• CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
• CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
• CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
• CTRL+Shift with any of the arrow keys (Highlight a block of text)
• Shift with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
• CTRL+A (Select all)
• F3 key (Search for a file or a folder)
• Alt+Enter (View the properties for the selected item)
• Alt+F4 (Close the active item, or quit the active program)
• Alt+Enter (Display the properties of the selected object)
• Alt+Spacebar (Open the shortcut menu for the active window)
• CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
• Alt+Tab (Switch between the open items)
• Alt+ESC (Cycle through items in the order that they had been opened)
• F6 key (Cycle through the screen elements in a window or on the desktop)
• F4 key (Display the Address bar list in My Computer or Windows Explorer)
• Shift+F10 (Display the shortcut menu for the selected item)
• Alt+Spacebar (Display the System menu for the active window)
• CTRL+ESC (Display the Start menu)
• Alt+Underlined letter in a menu name (Display the corresponding menu)
• Underlined letter in a command name on an open menu (Perform the corresponding command)
• F10 key (Activate the menu bar in the active program)
• RIGHT ARROW (Open the next menu to the right, or open a submenu)
• LEFT ARROW (Open the next menu to the left, or close a submenu)
• F5 key (Update the active window)
• Backspace (View the folder one level up in My Computer or Windows Explorer)
• ESC (Cancel the current task)
• Shift when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)

Dialog Box Keyboard Shortcuts

• CTRL+Tab (Move forward through the tabs)
• CTRL+Shift+Tab (Move backward through the tabs)
• Tab (Move forward through the options)
• Shift+Tab (Move backward through the options)
• Alt+Underlined letter (Perform the corresponding command or select the corresponding option)
• Enter (Perform the command for the active option or button)
• Spacebar (Select or clear the check box if the active option is a check box)
• Arrow keys (Select a button if the active option is a group of option buttons)
• F1 key (Display Help)
• F4 key (Display the items in the active list)
• Backspace (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts

• Win (Display or hide the Start menu)
• Win+BREAK (Display the System Properties dialog box)
• Win+D (Display the desktop)
• Win+M (Minimize all of the windows)
• Win+Shift+M (Restore the minimized windows)
• Win+E (Open My Computer)
• Win+F (Search for a file or a folder)
• CTRL+Win+F (Search for computers)
• Win+F1 (Display Windows Help)
• Win+ L (Lock the keyboard)
• Win+R (Open the Run dialog box)
• Win+U (Open Utility Manager)

Accessibility Keyboard Shortcuts

• Right Shift for eight seconds (Switch FilterKeys either on or off)
• Left Alt+left Shift+PRINT SCREEN (Switch High Contrast either on or off)
• Left Alt+left Shift+NUM LOCK (Switch the MouseKeys either on or off)
• Shift five times (Switch the StickyKeys either on or off)
• NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
• Win +U (Open Utility Manager)

Windows Explorer Keyboard Shortcuts

• END (Display the bottom of the active window)
• HOME (Display the top of the active window)
• NUM LOCK+* (Display all of the subfolders that are under the selected folder)
• NUM LOCK++ (Display the contents of the selected folder)
• NUM LOCK+- (Collapse the selected folder)
• LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
• RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut Keys for Character Map

• After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:
• RIGHT ARROW (Move to the right or to the beginning of the next line)
• LEFT ARROW (Move to the left or to the end of the previous line)
• UP ARROW (Move up one row)
• DOWN ARROW (Move down one row)
• PAGE UP (Move up one screen at a time)
• PAGE DOWN (Move down one screen at a time)
• HOME (Move to the beginning of the line)
• END (Move to the end of the line)
• CTRL+HOME (Move to the first character)
• CTRL+END (Move to the last character)
• Spacebar (Switch between Enlarged and Nor mal mode when a character is selected)

Microsoft Management Console (MMC) Main Window Keyboard Shortcuts

• CTRL+O (Open a saved console)
• CTRL+N (Open a new console)
• CTRL+S (Save the open console)
• CTRL+M (Add or remove a console item)
• CTRL+W (Close window/tab)
• F5 key (Update the content of all console windows)
• Alt+Spacebar (Display the MMC window menu)
• Alt+F4 (Close the console)
• Alt+A (Display the Action menu)
• Alt+V (Display the View menu)
• Alt+F (Display the File menu)
• Alt+O (Display the Favorites menu)

MMC Console Window Keyboard Shortcuts

• CTRL+P (Print the current page or active pane)
• Alt+- (Display the window menu for the active console window)
• Shift+F10 (Display the Action shortcut menu for the selected item)
• F1 key (Open the Help topic, if any, for the selected item)
• F5 key (Update the content of all console windows)
• CTRL+F10 (Maximize the active console window)
• CTRL+F5 (Restore the active console window)
• Alt+Enter (Display the Properties dialog box, if any, for the selected item)
• F2 key (Rename the selected item)
• CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote Desktop Connection Navigation

• CTRL+Alt+END (Open the m*cro$oft Windows NT Security dialog box)
• Alt+PAGE UP (Switch between programs from left to right)
• Alt+PAGE DOWN (Switch between programs from right to left)
• Alt+INSERT (Cycle through the programs in most recently used order)
• Alt+HOME (Display the Start menu)
• CTRL+Alt+BREAK (Switch the client computer between a window and a full screen)
• Alt+Delete (Display the Windows menu)
• CTRL+Alt+- (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
• CTRL+Alt++ (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing Alt+PRINT SCREEN on a local computer.)

Internet Explorer navigation

• CTRL+B (Open the Organize Favorites dialog box)
• CTRL+E (Open the Search bar)
• CTRL+F (Start the Find utility)
• CTRL+H (Open the History bar)
• CTRL+I (Open the Favorites bar)
• CTRL+L (Open the Open dialog box)
• CTRL+N (Start another instance of the browser with the same Web address)
• CTRL+O (Open the Open dialog box, the same as CTRL+L)
• CTRL+P (Open the Print dialog box)
• CTRL+R (Update the current Web page)
• CTRL+W (Close the current window)