MOST IMPORTANT EXCEL SHORTCUTS

  1. Ctrl + Shift + L: This shortcut toggles the filter on or off for the selected range. It's handy for quickly applying or removing filters without using the mouse.


  3. Alt + E + S: This shortcut sequence opens the Paste Special dialog box, allowing you to choose specific paste options such as values, formats, formulas, and more.


  5. Alt + Enter: While editing a cell, pressing Alt + Enter allows you to insert a line break within the cell. This is useful for creating multi-line text entries.


  7. Ctrl + ' (Apostrophe): This shortcut copies the value from the cell above the currently selected cell. It's a quick way to fill down a column with the value from the cell above.


  9. Ctrl + Alt + V: This shortcut opens the Paste Special dialog box directly in Values mode. It's a quicker way to paste values compared to using Alt + E + S followed by the V key.


  11. Ctrl + ; (semicolon): This shortcut inserts the current date into the selected cell. Similarly, Ctrl + Shift + ; (semicolon) inserts the current time.


  13. Ctrl + Shift + $: This shortcut applies the Currency format to the selected cells, formatting numbers with the appropriate currency symbol and decimal places.


  15. Ctrl + Spacebar: Selects the entire column of the currently active cell.


  17. Shift + Spacebar: Selects the entire row of the currently active cell.


  19. Ctrl + Shift + { or }: This shortcut selects all cells directly referenced by formulas within the selected range. It's useful for auditing and tracing precedents or dependents in your formulas.

Comments

Post a Comment

Popular posts from this blog

COMPUTER SHORTCUT KEYS

CTRL Shortcuts from A-Z: CTRL + A = Select text CTRL + B =  Bold  text CTRL + C = Copy text CTRL + D = Open font formatting window CTRL + E = Center text  CTRL + F = Find a phrase  CTRL + G = Go To a specific page or bookmark CTRL + H = Replace text with another text or replace text with different formatting CTRL + I =  Italicize  text CTRL + J = Justify text CTRL + K = Open  Insert Hyperlink  window CTRL + L = Left align text CTRL + M = Indent a paragraph from the left CTRL + N = Open new Word document CTRL + O = Open an existing Word document CTRL + P = Print Word document CTRL + Q = Remove paragraph formatting CTRL + R = Right align text CTRL + S = Save Word document CTRL + T = Create a hanging indent CTRL + U = Underline text CTRL + V = Paste text CTRL + W = Close Word document CTRL + X = Cut text CTRL + Y = Redo an action previously undone OR repeat an action CTRL + Z = Undo a previous action
Read more

CCC IMPORTANT QUESTIONS WITH ANSWER

  Sample Question Paper: Information Technology Tools and Network Basics (M1-R5.1) CCC    TOTAL TIME: 2 HOURS                                                                 TOTAL MARKS: 100   (Answer all the questions; each question carries ONE mark) Answer the following multiple choice questions (1 to 100) 1x100=100   Note: For each question, four options are given, Choose the most appropriate option .   1.          In Which Generation Time sharing, Real time Network and Distributed Operating Systems were used? (A)    ...
Read more