Advanced Excel Course MS Excel Shortcut Keys Notes Set 01

Advanced Study Material for Computer Science: MS Office

Explore structured advanced study materials through the Advanced Excel Course MS Excel Shortcut Keys Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.

Practice Computer Science Resources: MS Office

Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.

A list of the most useful Excel keyboard shortcuts: the Ctrl key combinations from A to Z, function-key shortcuts, row and column shortcuts, Alt key sequences for row height and column width, other keyboard shortcuts and the Alt + H + B border shortcuts.

Ctrl key shortcuts

ShortcutAction
Ctrl + ASelect All
Ctrl + BBold
Ctrl + CCopy
Ctrl + DFill Down: copies the data of the cell above into the selected cells below it, without using Ctrl + C
Ctrl + EFlash Fill
Ctrl + FFind
Ctrl + GGoTo: jumps to a given cell or page, for example from page 1 to page 10
Ctrl + IItalic
Ctrl + KHyperlink
Ctrl + LLeft Alignment
Ctrl + NNew Workbook
Ctrl + OOpen
Ctrl + PPrint
Ctrl + RRight Alignment
Ctrl + SSave
Ctrl + TTable Create
Ctrl + UUnderline
Ctrl + VPaste
Ctrl + WWorksheet Close
Ctrl + XCut
Ctrl + YRedo
Ctrl + ZUndo
Ctrl + Shift + CFormat Painter

Function key shortcuts with Ctrl

ShortcutAction
Ctrl + F1Show or Hide Ribbon
Ctrl + F2Print Preview
Ctrl + F3Name Manager
Ctrl + F6Switching Workbook: moves from one open workbook to another
Ctrl + F9Minimize Windows
Ctrl + F10Maximize Windows

Selecting, moving and inserting

ShortcutAction
Ctrl + SpaceSelect Current Column
Shift + SpaceSelect Current Row
Ctrl + Arrow KeyMove to the edge of the data region
Ctrl + HomeGoto First Cell
Ctrl + EndGoto Last Cell
Ctrl + +Add New Column or Row
Ctrl + -Delete Column or Row
Ctrl + :Insert Current Time
Ctrl + ;Insert Current Date

Row height and column width (Alt sequences)

ShortcutAction
Alt + O + R + ERow Height
Alt + O + C + WColumn Width
Alt + H + O + IColumn width Auto adjust
Alt + H + O + ARow Height Auto adjust

Excel other keyboard shortcuts

ShortcutParticulars
Ctrl + 0Hides the selected column
Ctrl + 9Hides the selected row
Ctrl + Shift + 0Unhides a column
Ctrl + Shift + 9Unhides a row
Ctrl + 1Opens the Format Cells window
Ctrl + 5Strikethrough: draws a line through the selected text
Ctrl + Shift + +Shows the Insert dialog box
Shift + F2Inserts a comment
Shift + F3Opens the Excel formula (Insert Function) box
Shift + F5Opens the Search (Find) box
Shift + F11Adds a new worksheet
F1Opens Microsoft Excel Help
F2Edits the selected cell
F4Repeats the last action
F7Spelling check of the selected text
F11Creates a chart of the selected data
F12Save As: saves any file under a new name
Shift + SpaceSelects all the cells of a row
Ctrl + SpaceSelects all the cells of a column
Alt + =Applies the AutoSum formula
Alt + F1Creates a chart
Alt + F8Displays the macros
Ctrl + Shift + &Puts an outline border
Ctrl + Shift + -Removes the borders
Ctrl + Shift + UExpands or collapses the formula bar

Border shortcut keys

Press Alt, then H, then B (the Borders button of the Home tab), and then the letter of the border.

KeysBorder
Alt + H + B then OBottom border
Alt + H + B then PTop border
Alt + H + B then LLeft border
Alt + H + B then RRight border
Alt + H + B then NNo borders
Alt + H + B then AAll borders
Alt + H + B then SOutside borders
Alt + H + B then TThick outside borders
Alt + H + B then BBottom double borders
Alt + H + B then HThick bottom borders
Alt + H + B then CTop and thick bottom border
Alt + H + B then UTop and double bottom border

Computer Science Exam Resources: MS Office

Quick Revision Material for MS Office

Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.

Expert Notes and Solved Exam Questions

Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within MS Office and demystifies standard marking schemes for Computer Science evaluations.

Additional Study Resources for

For peak performance in upcoming evaluations, integrate official Computer Science sample papers directly into your study schedule. Follow up your revision by attempting online MCQ tests for MS Office to refine calculation speed and precision.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.