W+S dialog box will appear. Alt + A + Show the Data Table W+T dialog box. Alt + Begin a new line within Enter the cell Show the Copy as Picture Alt + H + dialog box. C+P Remove everything. Alt + H + E+A Unambiguous hyperlinks Alt + H + E+L Specific comments Alt + H + E+M Remove all hyperlinks. The Fill Across Alt + H + Worksheets dialog box E+R will appear. Alt + H + FI + A Fill in the blanks Fill in the blanks on the Alt + H + left as follows: (1) Copy FI + J the right-most cell of a Alt + H + range into cells to the left; FI + L or (2) Copy from the right cell into the active cell. Alt + H + Show the Series dialog box. Fill out the form as follows: (1) Copy the lower cell of a selected range into the cells above, or (2) Copy the lower cell into the active cell. Show the Clipboard task
FI + S pane. Alt + H + Keep the source FI + U formatting when pasting values. Alt + H + Paste the linked image FO Alt + H + Picture to be pasted V+E Alt + H + Display all comments V+I Alt + H + Remove the comment V+U Alt + R + (1) Within the Formula A Bar or cell (in cell-editing mode), deletes 1 character to the left or the selection (if any); or (2) When not in cell-editing mode, clears the contents of the currently selected/active cell (s) Alt + R + Copy the formula/text D from the cell above and paste it into the active cell or Formula Bar. Backspace Copy the values/text from the cell above and paste them into the active cell or Formula Bar. Ctrl + ' Ctrl + Ctrl + \" Shift + ' Enter the current date. Bring up the Paste Special dialog box.
Ctrl + ; Copy Ctrl + Alt Alt + Fill in the blanks as + V H + V follows: (1) Copy the top + S cell of a range into the cells below; or (2) Copy from the cell above into the active cell. Ctrl + C Ctrl + Flash Fill to the end of the Insert current line Ctrl + D Alt + (1) Enter the current entry H + FI in the selected range + D while remaining in the same active cell, or (2) Complete cell entry while remaining in the same active cell. Ctrl + (1) Display the Insert Delete Hyperlink dialog box within a cell that does not have any hyperlinks; or (2) Display the Edit Hyperlink dialog box within a cell that does have a hyperlink. Ctrl + E Alt + H + FI Increase the size of the + F Quick Analysis tool Ctrl + Fill in the blanks as Enter follows: (1) Copy the left- most cell of a range into the cells to the right; or (2) Copy from the left cell into the active cell. Ctrl + K Enter the current time.
Ctrl + Q Enter the current time. Ctrl + R Alt + H + FI + R Paste\\sCut Ctrl + Clear the contents of the Shift + : currently selected/active cell (s) Ctrl + Deletes 1 character to the Shift + : right or the selection within the Formula Bar or cell (in cell-editing mode) (if any) Ctrl + V Alt + (1) Complete cell entry H + V within a cell or Formula + P Bar and (by default) move to the cell below; or (2) Within an AutoFilter list, filter the list using the selected item. Ctrl + X Alt + Cancel an entry within a H + X Formula Bar cell. Delete Alt + Delete H + E Active cell should be + C edited Show the Spelling dialog box. Enter Insert copied or cut cells when a row or column is selected. Esc Complete cell entry within the Formula Bar cell and (by default) move to the cell above. F2 Insert or remove a cell
F7 comment. Right Insert or change a cell Mouse + comment. Button + E The Thesaurus dialog box or task pane will be Shift displayed. Enter (1) Finish cell entry and Shift + move one cell to the left F10 + m in a worksheet or to the last unlocked cell in a Shift + F2 protected sheet; (2) Select a suggestion from Shift + F7 autocomplete to finish Shift + entry and move one cell Tab to the left or to the previous unlocked cell in a protected sheet. (1) Finish cell entry and move one cell to the right in a worksheet or to the next unlocked cell in a protected sheet; (2) Use an autocomplete suggestion to finish entry and move one cell to the right or to the next unlocked cell in a protected sheet. Paste special characters, omitting blanks Paste cell comments Make a special paste by performing an addition.
Tab When pasting, use transpose. Display Alt F10 Turn key tips (Ribbon keyboard shortcuts) On or Alt + W + F Off +F Alt + W + I Freeze Panes Alt + W + L Page Break Preview Alt + W + Q Normal View Alt + W + Display the Zoom dialog VG box View/hide gridlines Ctrl + ` Toggle between (1) displaying cell values and (2) displaying formulas in a worksheet Ctrl + 6 Alternate between hiding Ctrl + F1 and showing object(s) Ctrl + F10 Expand or collapse the Ribbon Maximize/restore a currently selected workbook window Ctrl + Scroll Zoom in/out Mouse Wheel Toggle between Ctrl + Shift + U expanding and collapsing the Formula Bar
Formatting (Ctrl Alt Paste conditional formatting + Alt + H of the destination and source + V) + V ranges together. +G +G (Ctrl Alt + Alt + H + V) + V + T + R Format for pasting. (Ctrl Alt + Alt + H + V) + V Copy and paste column + W + W widths. Alt +' Show the Style dialog box. Alt + Add or remove the bottom B border from the Format Cells dialog box's Border tab. Alt + Add/remove a downward D diagonal border from the Border tab of the Format Cells dialog box. Alt + Add/remove a horizontal H interior border from the Format Cells dialog box's Border tab when more than one row is selected. Alt + Increase the number of H+0 decimals that are shown. Alt + Double underlining can be
H+3 used or removed. +D Alt + Reduce the indent. H+5 Alt + Reduce the indent. H+5 Alt + Indent more deeply. H+6 Alt + Indent more deeply. H+6 Alt + Reduce the number of H+9 decimals that are displayed. Alt + To align the text at the H+ bottom of the cell. AB Align the text in the cell's Alt + center (between the left and H+ right). AC To align the text to the left of Alt + the cell. H+ Align the text in the cell's AL center (between the top and bottom). Alt + H+ Select an accounting format. AM Select the Number tab and Alt + the Accounting category to H+ open the Format Cells dialog AN box. To align the text to the right Alt + of the cell. H+ AN + M Alt + H+
AR Text aligned at the top of the cell. Alt + Expand the dropdown menu H+ for Borders. AT All Boundaries. Alt + H+B Double border at the bottom. Alt + The thick top and bottom H+B borders. +A Top and bottom borders are included. Alt + H+B Remove the border. +B Create a border grid. Alt + H+B Bottom border is thick. +C Choose the color of the Alt + border line. H+B +D Border on the left. With the Border tab selected, Alt + open the Format Cells dialog H+B +E Alt + H+B +G Alt + H+B +H Alt + H+B +I Alt + H+B +L Alt + H+B
+ M box. Alt + Ctrl H+B + + N Shift + - There is no border. Alt + H+B Bottom edge. +O Alt + H+B Border at the top. +P Alt + H+B Border on the right. +R Alt + Ctrl H+B + + S Shift + 7 Outside the border. Alt + H+B Box with a thick border. +T Alt + H+B Top and bottom borders are +U doubled. Alt + Make a border. H+B +W Select the border line style. Alt + The formatting is clear. H+B Select font color. +Y Alt + H+E +F Alt + H+
FC Increase the size of the Font Alt + Color dropdown menu. H+ FC Alter the font style. Alt + H+ Font size should be increased FF by one point. Alt + H+ 1 point is added to the font FG size. Alt + Reduce the font size by one H+ point. FG Reduce the font size by one Alt + point. H+ With the Number tab FK selected, open the Format Cells dialog box. Alt + With the Font tab selected, H+ open the Format Cells dialog FK box. Alt + Turn on the Format Painter. H+ FM Text should be rotated down. Text should be rotated Alt + clockwise. H+ FN Alt + H+ FP Alt + H+ FQ + D Alt + H+
FQ + L Alt + Alt H + + H With the Alignment tab FQ + + selected, open the Format M FA Cells dialog box. Alt + H+ Text should be rotated FQ + counterclockwise. O Alt + H+ FQ + Text should be rotated up. U Alt + H+ Verticalize the text by FQ + rotating it. V Alt + Increase or decrease the font H+ size. FS Alt + Increase the size of the Fill H+H Color dropdown menu. Alt + Fill the current cell selection H+H with no color. +N Alt + Increase the size of the Cell H+J Styles menu. Alt + To merge (copy) cell styles H+J from another workbook, +M open the Merge Styles dialog box. Alt + To create a new cell style, H+J open the Style dialog box.
+N Numbers should be formatted with a thousand comma (,) Alt + separator. H+K Alt + Remove all conditional H+L formatting rules from the +C+ worksheet. E Remove conditional Alt + H+L formatting rules from a +C+ P PivotTable. Alt + Remove conditional H+L +C+ formatting rules from the S cells you've chosen. Alt + H+L Remove conditional +C+ T formatting rules from the Alt + chosen table. H+L +D Expand the menu to create a conditional formatting rule with data bars with a gradient or a solid fill. Alt + Alt H + L + H Open the New Conditional + D + + L Formatting Rule dialog box M + S and select all cells based on + M their values rule type. Alt + Show the A Data Occurring H+L dialog box to conditionally +H+ format cells whose dates fall A within the time range specified in the rule. Alt + Open the Between dialog box
H+L to conditionally format cells +H+ whose values are between the B values specified in the rule. Alt + H+L Display the Duplicate Values +H+ dialog box to conditionally D format cells in the selected cell range with duplicate or Alt + unique values. H+L +H+ To conditionally format cells E whose value is equal to the value specified in the rule, Alt + open the Equal To dialog H+L box. +H+ G Open the Greater Than dialog box to conditionally Alt + format cells whose value is H+L greater than the value +H+ specified in the rule. L Open the Less Than dialog Alt + box to conditionally format H+L cells whose value is less than +H+ the value specified in the M rule. Alt + Select the Format only cells H+L containing the rule type +H+ option in the New T Conditional Formatting Rule dialog box. Alt + H+L Open the Text That Contains dialog box to conditionally format cells whose text contains the text specified in the rule. Expand the menu to use icon sets to create a conditional
+I formatting rule. Alt + The New Conditional H+L Formatting Rule dialog box +N will appear. Alt + The Conditional Formatting H+L Rules Manager will be +R displayed. Alt + Expand the menu to create a H+L color scale conditional +S formatting rule. Alt + To conditionally format cells H+L above the average in the +T+ selected cell range, open the A Above Average dialog box. Alt + Display the Bottom 10 Items H+L dialog box to conditionally +T+ format cells that are among B the lowest values in the selected cell range. Alt + H+L Select the Format only top or +T+ bottom ranked values rule M type in the New Conditional Formatting Rule dialog box. Alt + H+L To conditionally format cells +T+ that rank within a certain O bottom percentile in the selected cell range, open the Alt + Bottom 10% dialog box. H+L +T+ To conditionally format cells P that rank within a certain top percentile in the selected cell range, open the Top 10% dialog box.
Alt + To conditionally format cells H+L that rank among the top +T+ values in the selected cell T range, open the Top 10 Items dialog box. Alt + Open the Below Average H+L dialog box to conditionally +T+ format cells below the V average in the selected cell range. Alt + H+ Merge across cell boundaries. M+ A Cells should be merged. Alt + H+ Cells should be separated. M+ M Select a number format. Alt + H+ Row height should be auto- M+ fitted. U Alt + The Row Height dialog box H+N will appear. Alt + Column width should be H+O auto-fitted. +A The Column Width dialog Alt + H+O +H Alt + H+O +I Alt +
H+O box will appear. +W Activate the Format as Table Alt + dropdown menu. H+T Alt + Activate the Format as Table H+T menu. Alt + The New Table Style dialog H+T box will appear. +N The New PivotTable Style Alt + dialog box will appear. H+T +P Alt + Text should be wrapped. H+ W Add or remove the left border from the Format Cells Alt + dialog box's Border tab. L Alt + Add/remove the right border R from the Border tab of the Format Cells dialog box. Alt + Add or remove the top border T from the Format Cells dialog box's Border tab. Alt + Add/remove a vertical V interior border from the Format Cells dialog box's Border tab when more than one column is selected. Ctrl + Alt Format Cells 1 +H + O Show the + E dialog box.
Ctrl + Strikethrough formatting can 5 be used or removed. Ctrl + Ctrl Bold formatting can be used B + 2 or removed. Ctrl + Ctrl Italic formatting can be used I + 3 or removed. Ctrl + Shift + ! Use the number format. Ctrl + Shift + # Use the date format. Ctrl + Shift + $ Use the currency format. Ctrl + Alt Shift + H +% +P Use the percentage format. Ctrl + Outside borders should be Shift added to the selected cell (s). +& Use the time format. Ctrl + Shift Use a scientific format. +@ Remove all external borders. Ctrl + Shift Use a general format. +^ With the Font tab selected, Ctrl + Shift +_ Ctrl + Shift +~ Ctrl + Ctrl
Shift + open the Format Cells dialog + F Shift box. +P Ctrl + Ctrl The Create Table dialog box T + L will appear. Ctrl + Ctrl U + 4 Underlining can be added or removed. F4 When possible, repeat the previous command or action. Formulas And Functions (Ctrl Alt Paste formulas + Alt + H + V) + V +F +F (Ctrl Alt Paste link to + Alt + H source data + V) + V +L +N (Ctrl Alt Paste formulas + Alt + H and number + V) + V formatting +R +O = Start/enter a formula Alt + Alt AutoSum = +H +U +S Alt + Auto-calculate
H+ the average U+ using the A AVERAGE function Alt + H+ Auto-count U+ numbers using C the COUNT Alt + function H+ U+I Auto-calculate the minimum Alt + value within a H+ range using the U+ MIN function M Auto-calculate Alt + the maximum M+ value within a A+ range using the A MAX function Alt + M+ Remove D Arrows from Alt + Formula M+ Auditing P Alt + Trace Shift Dependents + F10 Trace Precedents Display menu or message generated by error background checking
Ctrl Display the The function name +A Function must already be typed, Arguments and the insertion point Ctrl dialog box and must be located to the + Alt insert function right of the function + F9 arguments name. Ctrl Ctrl + A is also under + F3 the Navigation and Cell Selection Ctrl category + Shift Calculate all This applies regardless +A worksheets in of whether the all open worksheets/workbooks Ctrl workbooks have been modified or + not since the previous Shift calculation. + Enter Display the Ctrl Name Manager + dialog box Shift + F3 Insert function Function name must F3 arguments have already been typed, and insertion point must be to the right of the function name Enter the formula as an array formula Display the Create Names There must be defined from Selection dialog box Display the
Paste Name names in the dialog box workbook for a command to available be F4 Toggles F9 between Shift suitable + F3 absolute and Shift + F9 relative Shift + reference Tab combinations. Calculate all worksheets in all open workbooks Alt Display the + H Insert Function + U dialog box +F Calculate the current active worksheet (1) Finish the Shift + Tab is also formula and under the Navigation move one cell and Selection and to the left in a Data categories worksheet or to the last unlocked cell in a protected sheet; (2) Select a suggestion from autocomplete to finish the
formula and move one cell to the left or to the previous unlocked cell in a protected sheet. Tab (1) Finish the formula and move one cell to the right in a worksheet or to the next unlocked cell in a protected sheet; (2) Use an autocomplete suggestion to finish the formula and move one cell to the right or to the next unlocked cell in a protected sheet. General Alt + Close current active F4 Excel window Alt + Display Control menu Space Alt + T Display Excel + O Options dialog box Ctrl + Redo/repeat last
Y action or command Ctrl + Z Undo/reverse last action or command Workbooks And Worksheets Alt + H Alt + E Remove the current active + D + S + L sheet. Alt + H Remove the active worksheet. +D+S Alt + H Alt + E + O + + M Show the Move or Copy sheet M dialog box. Alt + H Open the Move or Copy +O+ dialog box to move or copy M the active worksheet. Alt + H The Protect Sheet dialog box +O+P will appear. Alt + H Alt + O +O+ +H+ R R Rename the active sheet Alt + H +O+ rename the current worksheet R Alt + H Tab Extend the sheet Color +O+T selection menu Alt + H Tab Expansion Color selection +O+T menu Alt + H Set the current worksheet tab +O+T to be colorless. +N Bring up the Unhide sheet Alt + H dialog box. +O+ To unhide a worksheet, open U+H Alt + H
+O+ the Unhide dialog box. U+H Current active sheet should be Alt + H hidden. +O+ U+S The active worksheet should be hidden. Alt + H +O+ Add a new worksheet. U+S Create a new macro sheet Alt + Shift + Show the Open dialog box F1 Close the current workbook window. Ctrl + F11 Ctrl + F12 Ctrl + F4 Ctrl + Apply On the active workbook F7 window, move the command (when not maximized) Ctrl + Use the Resize command to F8 resize the active workbook window (when not maximized) Ctrl + Reduce the size of the F9 currently selected workbook window. Ctrl + Make a new workbook that is N entirely blank. Ctrl + Display Backstage should be O open. Consider this: (open a workbook) Ctrl + S Shift + Save the current file (1) with F12 the current file name and
format and (2) in the current file location. Ctrl + Close the chosen workbook W F12 Alt + F2 Show the Save As dialog box. Shift + Alt + H In the current workbook, add a F11 + I + S new worksheet.
END WORD Excel is fully equipped with powerful functions that allow it to meet the needs of everyone, whether for academic or business purposes. Further developments have only added to the great functionality of this Microsoft office application while maintaining its user-friendliness to be used by anyone of any skill level. What are the primary advantages of using Microsoft Excel? If it weren't for Microsoft Excel, organizing and comparing data could become time-consuming and overwhelming. It enables users to create lists and efficiently manage and compare them. In addition, the spreadsheet format of this application makes it easy to separate rows and columns of data. Whether you're working on business financial data or keeping track of your personal checkbook, Excel is a user-friendly application that makes tasks simple and easy. Microsoft Excel can also be used to complete math assignments, create mailing lists, and organize the book, music, and video collections. It can also be used to help you plan your family's budget. What are the benefits of using this application? With Excel, calculating is a piece of cake. The application allows you to compute the average, sum, difference, or product of a series of figures automatically. It also has functions that can handle more complex financial calculations and statistics. It can also be used to compare logical statements. Data analysis is one of the other functions. Data can be sorted, filtered, imported, and graphs and pivot tables can be created. It also includes many tools for proper formatting and customization. It isn't even tricky if you need to work on multiple spreadsheets at the same time. This is due to Excel's ability to create and manage multiple sheets within a single workbook. What are the most common applications for Microsoft Excel? Excel has a plethora of valuable features. However, the majority of people use it to create personal databases. This is because Excel is designed to make data collection, organization, and analysis easy and convenient. Because Excel
allows the creation of grids and charts, data can be further analyzed. Calculations are also simple to perform in Excel, regardless of the amount of data involved. As a result, it is ideal for business reports. Other applications for Microsoft Excel include inventory management, corporate budgeting, and profit breakeven analysis. Aside from these business applications, Excel is also a valuable tool for homemakers and students. That is why it is vital to learn about shortcut keys and their implementation. I hope this book will be a good reference point for you throughout your career in using Ms Excel.
Search
