CA Anurag Sharma
Quick Summary
Excel is one of the most powerful spreadsheets for your calculation, graphing tools,pivot tables, and macroprogramming needs. In this article, we will discuss 41 shortcuts on excel that can be done using the Ctrl Tab 1. Ctrl+A : Select all contents of a worksheet. 2. Ctrl+B : Bold all cells
Daily Limit Reached
You have reached your daily limit of 2 Free Articles
Subscribe to CCI PRO for unlimited access
Why Upgrade to CCI PRO?
- No Ads
- WhatsApp Broadcasts
- Daily E-Newsletter
- Unlimited Articles Access
BEST VALUE
2 YEAR PLAN
3,499
(Inclusive of GST)
1 YEAR PLAN
1,999
(Inclusive of GST)
View all CCI PRO benfits
Already a PRO member? Login here for an ad-free experience.
FAQ :
Basic Excel shortcuts include Ctrl+A to select all, Ctrl+B for bold, Ctrl+C to copy, Ctrl+V to paste, and Ctrl+S to save.
For file management, you can use Ctrl+O to open an existing workbook, Ctrl+N to create a new one, and Ctrl+W to close a workbook.
Text formatting shortcuts include Ctrl+B for bold, Ctrl+I for italics, and Ctrl+U for underline.
You can move to the previous sheet with Ctrl+PgUp and the next sheet with Ctrl+PgDn. Ctrl+Home moves to the beginning of the workbook, and Ctrl+End moves to the last used cell.
To hide a row, use Ctrl+9. To hide a column, use Ctrl+0. To unhide rows, use Ctrl+Shift+(, and to unhide columns, use Ctrl+Shift+).
You can insert the current time by pressing Ctrl+Shift+; and the date in dd/mm/year format by pressing Ctrl+Shift+#.
CAclubindia
