Microsoft Excel CTRL-SHIFT Combination Shortcut Keys

Microsoft Excel CTRL-SHIFT Combination Shortcut Keys:
Shortcut Keys to Work Smarter in Excel

The following table contains both CTRL and SHIFT combination shortcut keys along with descriptions of their functionality which one can use in Microsoft Excel to work more proficiently. Mastering these key will enable Excel user to skilfully enhance the speed and accuracy or work. The CTRL and SHIFT key can combine any other key on the keyboard, both the alphabet and number keys to perform special functions embedded in them. Constant usage and practice will enhance expertise in the use of these shortcut keys.

CTRL and SHIFT Combination Shortcut Keys

KEY	DESCRIPTION
CTRL+SHIFT+(	CTRL+SHIFT+( unhide any hidden rows within the selection.
CTRL+SHIFT+)	CTRL+SHIFT+) unhide any hidden columns within the selection.
CTRL+SHIFT+&	CTRL+SHIFT+& apply the outline border to the selected cells.
CTRL+SHIFT+_	CTRL+SHIFT+ remove the outline border from the selected cells.
CTRL+SHIFT+~	CTRL+SHIFT+~ apply the General number format.
CTRL+SHIFT+$	CTRL+SHIFT+$ apply the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%	CTRL+SHIFT+% apply the Percentage format with no decimal places.
CTRL+SHIFT+^	CTRL+SHIFT+^ apply the Exponential number format with two decimal places.
CTRL+SHIFT+#	CTRL+SHIFT+# apply the Date format with the day, month, and year.
CTRL+SHIFT+@	CTRL+SHIFT+@ apply the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!	CTRL+SHIFT+! apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*	CTRL+SHIFT+* select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+:	CTRL+SHIFT+: enter the current time.
CTRL+SHIFT+"	CTRL+SHIFT+" copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+Plus (+)	CTRL+Plus (+) display the Insert dialog box to insert blank cells.
CTRL+Minus (-)	CTRL+Minus (-) display the Delete dialog box to delete the selected cells.
CTRL+;	CTRL+; enter the current date.
CTRL+`	CTRL+` alternate between displaying cell values and displaying formulas in the worksheet.
CTRL+'	CTRL+' copy a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1	CTRL+1 display the Format Cells dialog box.
CTRL+2	CTRL+2 apply or removes bold formatting.
CTRL+3	CTRL+3 apply or removes italic formatting.
CTRL+4	CTRL+4 apply or remove underlining.
CTRL+5	CTRL+5 apply or remove strikethrough.
CTRL+6	CTRL+6 alternate between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+8	CTRL+8 display or hides the outline symbols.
CTRL+9	CTRL+9 hide the selected rows.
CTRL+0	CTRL+0 hide the selected columns.
CTRL+A	CTRL+A select the entire worksheet. If the worksheet contains data, CTRL+A select the current region. Pressing CTRL+A the second time select the current region and its summary rows. Pressing CTRL+A the third time select the entire worksheet. When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. CTRL+SHIFT+A insert the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B	CTRL+B applie or remove bold formatting.
CTRL+C	CTRL+C Copy the selected cells. CTRL+C followed by another CTRL+C display the Clipboard.
CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F	CTRL+F displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also display this tab, while SHIFT+F4 repeat the last Find action. CTRL+SHIFT+F open the Format Cells dialog box with the Font tab selected.
CTRL+G	CTRL+G display the Go To dialog box. F5 also displays the same Go To dialog box.
CTRL+H	CTRL+H display the Find and Replace dialog box, with the Replace tab selected.
CTRL+I	CTRL+I apply or remove italic formatting.
CTRL+K	CTRL+K display the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N	CTRL+N Create a new, blank workbook.
CTRL+O	CTRL+O display the Open dialog box to open or find a file. CTRL+SHIFT+O select all cells that contain comments.
CTRL+P	CTRL+P displays the Print dialog box. CTRL+SHIFT+P open the Format Cells dialog box with the Font tab selected.
CTRL+R	CTRL+R use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S	CTRL+S save the active file with its current file name, location, and file format.
CTRL+T	CTRL+T displays the Create Table dialog box.
CTRL+U	CTRL+U apply or remove underlining. CTRL+SHIFT+U switch between expanding and collapsing of the formula bar.
CTRL+V	CTRL+V Insert the contents of the Clipboard at the insertion point and replace any selection. Available only after you have cut or copied an object, text or cell contents.
CTRL+W	CTRL+W Close the selected workbook window.
CTRL+X	CTRL+X Cut the selected cells.
CTRL+Y	CTRL+Y repeat the last command or action, if possible.
CTRL+Z	CTRL+Z use the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHIFT+Z use the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

How Do I Save Workbook in PDF?

Saving Workbook in PDF (Portable Document Format)

PDF is a fixed-layout electronic file format that preserves document formatting and enables file sharing. The PDF ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot easily be changed. The PDF is also useful for documents that will be reproduced by using commercial printing methods.

To view a PDF file, you must have a Adobe Acrobat Reader or other PDF reader installed on your computer. When a workbook is saved as PDF, you cannot use your MS Excel that created it to make changes directly to the file. You must make changes to the original workbook in the MS Office release program in which you created it and save the file as PDF again. You can save as a PDF from a Microsoft Office Excel 2007 only after you install an add-in which you will get from this website: microsoft.com and follow the instructions on that page to istall the add-in. However, the download is available to only customers running genuine Microsoft Office software.

Now you can take the following steps to save a workbook in PDF:

METHOD 1:

1. Open the Workbook you want to convert to PDF, click the Microsoft Office button and click Print.
2. From the Printer Name box select the PDF printer from the list of available printers and click Ok.
3. The PDF window appears. Enter a name and location for the PDF file. You can also set other PDF options at this time.
4. Click Create PDF.

METHOD 2:

1. Click the Microsoft Office Button or Click File on the Menu Bar, point to the arrow next to Save As or Click Save As, and then click PDF.
2. In the File Name list, type or select a name for the workbook.
3. In the Save as type list, click PDF.
4. If you want to open the file immediately after saving it, select the Open file after publishing check box. This check box is available only if you have a PDF reader installed on your computer.
5. Next to Optimize for, do one of the following, depending on whether file size or print quality is more important to you:
1. If the workbook requires high print quality, click Standard (publishing online and printing).
2. If the print quality is less important than file size, click Minimum size (publishing online).
6. Click Publish.

 

METHOD 3:

1. Click File on the menu bar, click Save As.
2. In the File Name list, type or select a name for the workbook.
3. In the Save as type list, click PDF.
4. If you want to open the file immediately after saving it, select the Open file after publishing check box. This check box is available only if you have a PDF reader installed on your computer.
5. Click Save.

How Do I Work in Microsoft Excel?

Working in Microsoft Excel

To be able to work effectively if MS Excel, one need to be able to navigate the worksheet. This can be done by using the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. In Microsoft Office Excel 2007, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and tooltips that let you know where you are in the worksheet. There are different ways to scroll through a worksheet. You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars.

To scroll	Do this
To the start and end of ranges	Press CTRL+ARROW key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet. To scroll to the start and end of each range while at the same time, selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+ARROW key.
One row up or down	Press SCROLL LOCK on the keyboard, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.
One column left or right	Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right.
One window up or down	Press PAGE UP or PAGE DOWN.
One window left or right	Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key.
A large distance	Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.