Microsoft Excel shortcut keys

Microsoft Excel shortcut keys

Under is a listing of all of the essential shortcut keys usable in Microsoft Excel. See the laptop shortcut web page if you are looking for shortcut keys utilized in different programs

Shortcut	Description
F2	Edit the selected cell.
F3	After a name has been created, F3 will paste names.
F4	Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5	Go to a specific cell. For example, C6.
F7	Spell check selected text or document.
F11	Create chart from selected data.
Ctrl + Shift + ;	Enter the current time.
Ctrl + ;	Enter the current date.
Alt + Shift + F1	Insert New Worksheet.
Alt + Enter	While typing text in a cell, pressing Alt + Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift + F3	Open the Excel formula window.
Shift + F5	Bring up search box.
Ctrl + 1	Open the Format Cells window.
Ctrl + A	Select all contents of the worksheet.
Ctrl + B	Bold highlighted selection.
Ctrl + I	Italic highlighted selection.
Ctrl + K	Insert link.
Ctrl + S	Save the open worksheet.
Ctrl + U	Underline highlighted selection.
Ctrl + 1	Change the format of selected cells.
Ctrl + 5	Strikethrough highlighted selection.
Ctrl + P	Bring up the print dialog box to begin the printing process.
Ctrl + Z	Undo last action.
Ctrl + F3	Open Excel Name Manager.
Ctrl + F9	Minimize current window.
Ctrl + F10	Maximize currently selected window.
Ctrl + F6	Switch between open workbooks or windows.
Ctrl + Page up	Move between work sheets in the same document.
Ctrl + Page down	Move between work sheets in the same document.
Ctrl + Tab	Move between Two or more open Excel files.
Alt + =	Create a formula to sum all of the above cells.
Ctrl + '	Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + 1	Format number in comma format.
Ctrl + Shift + 4	Format number in currency format.
Ctrl + Shift + 3	Format number in date format.
Ctrl + Shift + 5	Format number in percentage format.
Ctrl + Shift + 6	Format number in scientific format.
Ctrl + Shift + 2	Format number in time format.
Ctrl + Arrow key	Move to next section of text.
Ctrl + Space	Select entire column.
Shift + Space	Select entire row.
Ctrl + -	Delete the selected column or row.
Ctrl + Shift + =	Insert a new column or row.
Ctrl + Home	Move to cell A1.
Ctrl + ~	Switch between showing Excel formulas or their values in cells.

Microsoft Word shortcut keys

Microsoft Word shortcut keys

Below is a listing of the greater usually used shortcut keys in Microsoft phrase. See the pc shortcut page if you are looking for a list of shortcut keys used in other packages. Please be aware that some of those shortcuts won't work in all variations of Microsoft word.

Observe: If the device you are using does not have feature keys (F1-F12) on its keyboard, like a Chromebook, certain shortcuts will be unavailable to you.

Shortcut	Description
Ctrl + 0	Toggles 6pts of spacing before a paragraph.
Ctrl + A	Select all contents of the page.
Ctrl + B	Bold highlighted selection.
Ctrl + C	Copy selected text.
Ctrl + D	Open the font preferences window.
Ctrl + E	Aligns the line or selected text to the center of the screen.
Ctrl + F	Open find box.
Ctrl + I	Italic highlighted selection.
Ctrl + J	Aligns the selected text or line to justify the screen.
Ctrl + K	Insert a hyperlink.
Ctrl + L	Aligns the line or selected text to the left of the screen.
Ctrl + M	Indent the paragraph.
Ctrl + N	Opens new, blank document window.
Ctrl + O	Opens the dialog box or page for selecting a file to open.
Ctrl + P	Open the print window.
Ctrl + R	Aligns the line or selected text to the right of the screen.
Ctrl + S	Save the open document. Just like Shift + F12.
Ctrl + T	Create a hanging indent.
Ctrl + U	Underline the selected text.
Ctrl + V	Paste.
Ctrl + W	Close the currently open document.
Ctrl + X	Cut selected text.
Ctrl + Y	Redo the last action performed.
Ctrl + Z	Undo last action.
Ctrl + Shift + L	Quickly create a bullet point.
Ctrl + Shift + F	Change the font.
Ctrl + Shift + >	Increase selected font +1pts up to 12pt and then increase font +2pts.
Ctrl + ]	Increase selected font +1pts.
Ctrl + Shift + <	Decrease selected font -1pts if 12pt or lower; if above 12, decreases font by +2pt.
Ctrl + [	Decrease selected font -1pts.
Ctrl + / + c	Insert a cent sign (¢).
Ctrl + ' + <char>	Insert a character with an accent (grave) mark, where <char> is the character you want. For example, if you wanted an accented è you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + *	View or hide non printing characters.
Ctrl + <left arrow>	Moves one word to the left.
Ctrl + <right arrow>	Moves one word to the right.
Ctrl + <up arrow>	Moves to the beginning of the line or paragraph.
Ctrl + <down arrow>	Moves to the end of the paragraph.
Ctrl + Del	Deletes word to right of cursor.
Ctrl + Backspace	Deletes word to left of cursor.
Ctrl + End	Moves the cursor to the end of the document.
Ctrl + Home	Moves the cursor to the beginning of the document.
Ctrl + Spacebar	Reset highlighted text to the default font.
Ctrl + 1	Single-space lines.
Ctrl + 2	Double-space lines.
Ctrl + 5	1.5-line spacing.
Ctrl + Alt + 1	Changes text to heading 1.
Ctrl + Alt + 2	Changes text to heading 2.
Ctrl + Alt + 3	Changes text to heading 3.
Alt + Ctrl + F2	Open new document.
Ctrl + F1	Open the Task Pane.
Ctrl + F2	Display the print preview.
Ctrl + Shift + >	Increases the selected text size by one.
Ctrl + Shift + <	Decreases the selected text size by one.
Ctrl + Shift + F6	Switches to another open Microsoft Word document.
Ctrl + Shift + F12	Prints the document.
F1	Open Help.
F4	Repeat the last action performed (Word 2000+)
F5	Open the Find, Replace, and Go To window in Microsoft Word.
F7	Spellcheck and grammar check selected text or document.
F12	Save As.
Shift + F3	Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7	Runs a Thesaurus check on the selected word.
Shift + F12	Save the open document. Just like Ctrl + S.
Shift + Enter	Create a soft break instead of a new paragraph.
Shift + Insert	Paste.
Shift + Alt + D	Insert the current date.
Shift + Alt + T	Insert the current time.

You can also make use of the mouse to perform some commonplace movements. the following section consists of examples of mouse shortcuts.

Mouse shortcuts	Description
Click, hold, and drag	Selects text from where you click and hold to the point you drag and let go.
Double-click	If double-clicking a word, selects the complete word.
Double-click	Double-clicking on the left, center, or right of a blank line makes the alignment of the text left, center, or right aligned.
Double-click	Double-clicking anywhere after text on a line will set a tab stop.
Triple-click	Selects the line or paragraph of the text that the mouse triple-clicked on.
Ctrl + Mouse wheel	Zooms in and out of document.

How to move the mouse cursor with the keyboard in Windows

How to move the mouse cursor with the keyboard in Windows

Whether your mouse breaks, runs out of batteries, or in case you want to have an alternative way to the cursor, you could use the arrow keys on the numeric keypad. earlier than intending, make sure the Num Lock characteristic is toggled on by way of pressing the key till you notice an indicator light, or can type numbers with the keypad.

• Shortcut key combo
• Windows 10
• Windows 8
• Windows 7, Vista, or XP
• How to use Mouse Keys

Shortcut in all versions of Windows

• Press Left Alt + Left Shift + Num Lock to your keyboard on the identical time.
• when the window seems, press Spacebar or input.
• Repeat this procedure to show Mouse Keys off.

Windows 10

If the shortcut key mixture listed above did now not paintings, you can enable or disable Mouse Keys, using the subsequent steps. in case your mouse isn't working, use the Tab key and Spacebar to navigate via menus.

• Press the home windows key in your keyboard.
• inside the field that looks, type Ease of get admission to mouse settings and press enter.
• in the Mouse Keys phase, toggle the transfer beneath Use numeric pad to transport mouse around the screen to On.
• Press Alt + F4 to go out this menu.

Windows 8

If the shortcut key combination indexed above did not work, you can allow or disable Mouse Keys, using the following steps. in case your mouse isn't working, use the Tab key and Spacebar to navigate through menus.

• With not anything selected, type the word "Mouse" anywhere at the begin screen.
• Arrow all the way down to Ease of get admission to mouse settings and press enter.
• Toggle the transfer beneath Mouse Keys to On.
• Press Alt + F4 to exit this menu.

Windows XP, Vista and 7

If the shortcut key mixture listed above did now not paintings, you could permit or disable Mouse Keys the usage of the following steps. in case your mouse isn't always operating, use the Tab key and Spacebar to navigate thru menus.

• While viewing the laptop, press the home windows Key or click begin within the lower left-hand corner.
• Pick out manipulate Panel from the list on the proper-hand side.
• Inside the control Panel, open Ease of get right of entry to.
• Below Ease of get right of entry to middle, pick change how your mouse works.
• Check the container next to turn on Mouse Keys.
• Pick out observe then ok.

Tip: if you need to trade the cursor's motion velocity or other settings, pick installation Mouse Keys.

How to use Mouse Keys

The subsequent table shows each of the keys on the Numeric Keypad and how they have interaction with the mouse cursor. ensure you are only using the Keypad to execute those moves.

Desired Action	Key Combination
Move up and to the left	Press 7
Move up	Press 8
Move up and to the right	Press 9
Move left	Press 4
Move right	Press 6
Move down and to the left	Press 1
Move down	Press 2
Move down and to the right	Press 3
Select the left mouse button	Press /
Select both of the mouse buttons	Press *
Select the right mouse button	Press -
Click	With the left button selected, press 5
Right-click	With the right button selected, press 5
Double-click	With the left button selected, press +
Drag an item	Point to the item, and then press 0
Drop the item you are dragging	Press .

Computer keyboard shortcut keys

Computer keyboard shortcut keys

Shortcut keys ABCs

Shortcut keys assist provide an less difficult and commonly faster method of navigating and executing instructions in pc software program packages. Shortcut keys are typically accessed with the aid of the use of the Alt key (on IBM compatible computer systems), Command key (on Apple computer systems), Ctrl key, or Shift key along with any other key. The de facto preferred for listing a shortcut is listing the modifier key, a plus image, and another key. In different phrases, "Ctrl+S" is telling you to press and maintain the Ctrl key, after which press the S key too.

You may also locate the shortcut keys to their most famous program by means of seeking out underlined letters of their menus. as an example, the picture to the right has an underline at the "F" in file, this means that you may press the Alt key and then the "F" key to get right of entry to the document menu.

A few packages require the consumer to press and hold Alt to peer the underlined characters. inside the equal image above, you can see that a number of the common features, including Open (Ctrl+O) and store (Ctrl+S), have shortcut keys assigned to them. As you start to memorize shortcut keys, you may note that many applications proportion the equal shortcut keys. we've a list of the maximum generally shared ones inside the fundamental pc shortcut keys segment.

Tip: customers out of doors america or who've a foreign replica of Microsoft home windows or a Microsoft software may not be capable of use all of the underneath shortcut keys.

Basic Computer shortcut keys

Under is a listing of some of the most commonly used basic shortcut keys that work with almost all IBM well matched computers and software program packages. it is exceptionally recommended that every one customers preserve a terrific reference of those shortcut keys or try to memorize them. Doing so will dramatically increase your productiveness.

Tip: except the unique man or woman shortcuts listed here, a few unique characters are also positioned at the range keys (under the F1 - F12 keys). you could input these unique characters by way of pressing the Shift key and the range key that has the special man or woman indexed on it.

Shortcut Keys	Description
Alt + F	File menu options in current program.
Alt + E	Edit options in current program
Alt + Tab	Switch between open programs
F1	Universal Help in almost every Windows program.
F2	Rename a selected file
F5	Refresh the current program window
Ctrl + N	Create a new, blank document in some software programs
Ctrl + O	Open a file in current software program
Ctrl + A	Select all text.
Ctrl + B	Change selected text to be Bold
Ctrl + I	Change selected text to be in Italics
Ctrl + U	Change selected text to be Underlined
Ctrl + F	Open find window for current document or window.
Ctrl + S	Save current document file.
Ctrl + X	Cut selected item.
Shift + Del	Cut selected item.
Ctrl + C	Copy selected item.
Ctrl + Ins	Copy selected item
Ctrl + V	Paste
Shift + Ins	Paste
Ctrl + K	Insert hyperlink for selected text
Ctrl + P	Print the current page or document.
Home	Goes to beginning of current line.
Ctrl + Home	Goes to beginning of document.
End	Goes to end of current line.
Ctrl + End	Goes to end of document.
Shift + Home	Highlights from current position to beginning of line.
Shift + End	Highlights from current position to end of line.
Ctrl + Left arrow	Moves one word to the left at a time.
Ctrl + Right arrow	Moves one word to the right at a time.
Ctrl + Esc	Opens the START menu
Ctrl + Shift + Esc	Opens Windows Task Manager
Alt + F4	Close the currently active program
Alt + Enter	Open the Properties for the selected item (file, folder, shortcut, etc.)

Computer shortcut keys for Special Characters

There are many unique characters that may be created the usage of keyboard shortcuts. below are a number of the extra not unusual and popular unique characters and the keyboard shortcuts to create them.

Shortcut Keys	Special Character
Alt + 0224	à
Alt + 0232	è
Alt + 0236	ì
Alt + 0242	ò
Alt + 0241	ñ
Alt + 0228	ä
Alt + 0246	ö
Alt + 0252	ü
Alt + 0248	ø
Alt + 0223	ß
Alt + 0198	Æ
Alt + 0231	ç
Alt + 0191	¿
Alt + 0176	°  (degree symbol)
Alt + 0177	±  (plus/minus symbol)
Alt + 0153	™
Alt + 0169	©
Alt + 0174	®
Alt + 0128	€  (Euro currency)
Alt + 0162	¢  (Cent symbol)
Alt + 0163	£  (British Pound currency)
Alt + 0165	¥  (Japanese Yen currency)

• Shortcut keys ABCs
• Basic PC shortcut keys
• PC shortcut keys for Special Characters
• Microsoft Windows shortcut keys
• Apple shortcut keys
• Linux and Unix shortcut keys
• F1 - F12 function keys
• Top 10 keyboard shortcuts
• Microsoft Excel shortcut keys
• Microsoft Word shortcut keys
• Internet Explorer shortcut keys
• Microsoft FrontPage shortcut keys
• Microsoft Outlook shortcut keys
• Mozilla Firefox keyboard shortcuts
• YouTube keyboard shortcuts
• Keyboard terms
• How do I create a Windows shortcut key?

Why am I unable to view a web page's source code?

Why am I unable to view a web page's source code?

Every net page at the net ought to can help you view the supply code; there may be no software or script which could disable this feature in the browser. however, users using Microsoft internet Explorer may stumble upon an problem in which the option to view an internet page's supply code is grayed out. This issue can be caused by any of the motives beneath.

Too many files in the Internet Cache

Make certain your net Cache and records is cleared out. Having too much information within the cache or corrupt files ought to motive numerous troubles to occur in internet Explorer.

Low system resources

Low system resources can motive this difficulty. close any applications that you are not the use of, inclusive of internet Explorer after which re-open net Explorer and you need to be capable of view the supply.

How to save a picture from e-mail

How to save a picture or image from email

Whilst a image is despatched over email, it's miles carried out so as an attachment. maximum e-mail applications, each on line and off, show any attachment cut loose the real message. To view and keep the attached photo, you could want to open or download the picture document. the following sections element the stairs important to store pics in more than one applications.

• Internet e-mail
• Mozilla Thunderbird
• Microsoft Outlook
• E-mail on iPad

Internet email

Most on-line e-mail structures, like Gmail, Outlook.com (previously Hotmail), stay Mail, and Yahoo! Mail, work in a comparable way and provide similar functionality for saving pictures and report attachments.

• Login for your e-mail account the usage of your favourite internet browser and open the email containing the photograph or picture you need to keep.
• Proper-click the image and pick out the choice to store photo As, shop image As, or keep image.
• Specify the region wherein you need to save the report. you can also trade the filename at this factor.

Tip: If the steps above do not paintings on your online electronic mail account and electronic mail messages, see if there may be an choice to save the entire email message for your laptop. this option and the stairs to accomplish that may also vary via e-mail provider, however doing so may fit to keep the picture itself on your computer as a separate report, along with the e-mail message itself.

Mozilla Thunderbird

• Open the email with the attached photo.
• proper-click at the photograph or the icon of the image document and pick shop As or keep photograph.
• Specify the region you need to save the record. you may additionally trade the filename at this factor.

Microsoft Outlook

In more moderen variations of Outlook which include Outlook 2010: if the photo is connected as a separate record instead of being pasted into the message frame, you can right-click on at the document attachment and pick save As. you could then keep the photo report to anywhere to your laptop. If there are a couple of pics attached to the e-mail, you could additionally select the shop All Attachments option and store all of the photo documents for your computer.

In older versions of Outlook prior to Outlook 2007, there is no 'right-click to shop' alternative just like the others. but, there are a few workarounds you can use to shop your e mail pix. maintain in thoughts, you can must strive multiple choice relying to your model of Outlook.

• Open the email message and under the Message tab, select other actions, then View in Browser. This method permits you to save your pix the same manner you will with internet email (listed above).
• you could reproduction the image to the clipboard and paste it into picture enhancing software, which includes Paint or Photoshop. One the image has been pasted, you could save it via deciding on file from the menu on the pinnacle left-hand nook of the screen after which selecting shop or keep As from the drop down menu.
• Open the e-mail message and keep it as an HTML record by means of clicking document at the pinnacle left-hand nook, then choosing store As from the drop down menu and deciding on the format web web page. This method saves all of the embedded snap shots in a single folder making it useful when you need to down load multiple pix from the identical message.

E-mail on iPad

If you are viewing email on an iPad and need to shop photos to the iPad out of your electronic mail messages, observe those steps.

• Open the email message
• Tap on the photo inside the email to view the photo fullscreen.
• Tap the arrow inside the higher proper nook of the display and pick save photo.

Snap shots saved using this manner should be handy inside the photo album on the iPad.

How to copy text and images from a web page

How to copy text and images from a web page

How to copy text from a web page

to replicate text from an internet web page, locate the beginning of the textual content you need to copy. Press and maintain the left mouse button and then drag the mouse from the top left to the lowest right of the entire choice of textual content you need to copy. everything this is highlighted may be copied.

to replicate the text, on your keyboard, press the keyboard shortcut CTRL+C or right-click on the highlighted textual content and click reproduction.

to stick text, location your cursor wherein you need it to be pasted and press the keyboard shortcut CTRL+V or right-click where you want to paste the text and click Paste.

The text could be copied from the internet web page to a brand new or existing record. From there, you may change the formatting of the text (bold, italics, font coloration or length, and so on.).

Tip: while pasting textual content right into a program inclusive of Microsoft phrase that helps formatting, the layout, font, and format of the textual content can be copied in conjunction with the textual content. in case you need to copy textual content with out the formatting, use the paste unique or paste text feature of this system you're pasting the text.

How to copy an image from a web page

To save an picture, proper-click on any picture on a website to view the properties menu for that photo, as proven under. in case you want to replicate that photo into another file, click the copy picture choice from the menu. in case you want to keep the picture file in your laptop, so it is able to be used or uploaded somewhere else choose the shop photograph as alternative.

observe: The above instance of the proper-click on menu is in Google Chrome. if you are the usage of internet Explorer or some other internet browser, your menu alternatives may additionally range. you can see alternatives for reproduction and keep photograph as. Use those alternatives, in preference to the alternatives stated above, to obtain the equal effects.

if you selected the save photograph as alternative, a shop As or keep image window might open, allowing you to pick where to save the photo and to change the call. click on the keep button to keep the image on your laptop.

notice: a few net pages may additionally disable the proper-click on ability or have their web page setup to save you the copying or saving of photographs using the above technique.

Pasting the picture

if you selected the replica picture alternative, that photo is stored to the clipboard. to stick the photograph, circulate the cursor to in which you need to paste and press CTRL+V or proper-click on in which you need to paste the photograph and pick Paste.

notice: A simple text application, such as Notepad, does no longer assist pix and the paste option will now not be to be had.

Is it legal to copy a website's text and images?

The act of copying text and images is not unlawful. however, how you operate the facts may be restricted by way of the net web page's copyright. as an example, copying all textual content from a web page and the usage of it on some other internet web page is towards maximum web sites' copyrights due to the fact it's far duplicating their content.

in case you are not certain about the copyright rules, touch the writer of the article or the webmaster of the web web page asking for permission to apply their content.

Tip: most copyright related data is discovered within the copyright hyperlinks or legal pages located on the bottom of maximum net pages.

Additional Tips

Online Services

There are dozens of on line services which can help percentage textual content between computers and different internet users on-line. below are  of our favorites.

Pastebin - by using some distance one of the great locations to paste your code and other text. The carrier calls for no login to stick textual content but does provide a login option for those wanting to edit or delete posted textual content. The service additionally has browser plugins to stick textual content and apps for all foremost smartphones and pill gadgets.

Evernote - one of the maximum famous online sharing offerings. Evernote is a unfastened collaboration and word taking provider that permits you to save notes, clippings, video, images, phrase documents, and much greater.

Browser plugins

ScrapBook - This wonderful plugin allows any Firefox person to shop net pages or even snippets of web pages to examine and edit or view later.

-How to copy text and images from a web site page