Skip to main content

Excel Keyboard Shortcuts

Excel TipsThe Best Shortcut Keys in Microsoft Excel
 CA Community For CA    

Ctrl+ZUndo
Ctrl+C
Enter,
Ctrl+V
Ctrl+X		Copy,
Paste,
Multiple Paste,
Cut
Ctrl+F,
Ctrl+H		Find,
Find&Replace
Ctrl+P,
Ctrl+S, Ctrl+F4, Alt+F4		Print,
Save, Close,
Close
Excel
Ctrl+ArrowMove
to edge of region
Ctrl+* Select
current region
Ctrl+ASelect
all cells
Ctrl+Home
Ctrl+End		Select
A1,
Select
last cell in used range
Ctrl+Shift+EndSelect
from active cell to last cell in used range.
Ctrl+Shift+HomeSelect
from active cell to A1
Ctrl+Page
Down
Ctrl+Page
Up		Move
to the next sheet,
Move
to the previous sheet
Ctrl+TabMove
to next open workbook
Ctrl+NOpen
new workbook
Shift+F11Insert
new worksheet
Shift+F3Paste
function window
=+FunctionName+Ctrl+AInsert
new function
Alt+F11Open
VBE
Ctrl+Shift+EnterArray
formula
Ctrl+F3,
F3		Define
name, Paste name
Ctrl+Spacebar
Shift+Spacebar		Select
columns, Select rows
Ctrl+1,
Ctrl+B, Ctrl+U		Format
cells, Bold, Underline
Ctrl+;
, Ctrl+shift+:		Current
date, Current time
Labels:

Popular posts from this blog

File your ITR Return 2023-2024

Income Tax E-Filing E-file your income tax return (ITR) online through IndiaFilings quickly at lowest price. Get support from income tax experts for ITR filing. 2 Exclusive Offers                                                Personal - Salaried                                                Personal - Self Employed                                                File Revised Return                                ...
Post a Comment
Read more

Standards on Auditing - Not a choice but a compulsion

What are Auditing Standards? The Standards on Auditing is an area which requires greater focus of CA in practice as well as our administrative bodies who are updating our members. The Companies Act 2013 has discussed it in detail which was absent in erstwhile act. As per Sec 2 (7) “auditing standards” means the standards of auditing or any addendum thereto for companies or class of companies referred to in sub-section (10) of section 143. Sec 143 (9) reads “Every auditor shall comply with the auditing standards.”                 As per Sec 143 (10) The Central Government may prescribe the standards of auditing or any addendum thereto, as recommended by the Institute of Chartered Accountants of India, constituted under section 3 of the Chartered Accountants Act, 1949, in consultation with and after examination of the recommendations made by the National Financial Reporting Authority: Provided that until any auditing standards ar...
Read more

9 Smart Ways To Boost Reader Engagement On Your Blog

Are you struggling to get your readers to engage with your blog? When I started blogging, I struggled too. But then I found that people who have an engaged audience on their blogs have this one thing in common: Their content is interesting. “How can I make my content interesting?” Well, that’s what I will be answering in this guide. I know how it feels when your readers read all your posts but don’t take the time to comment or share. I know it hurts. Reader engagement is the key to building a massive community of fans. Your readers engage with your blog in a lot of different ways. This engagement could take place in any of the following forms: Commenting on your blog posts Sharing your blog posts Navigating to another blog post Subscribing to your newsletters Or simply taking some action Reader engagement is also a search engine ranking factor. Google uses the bounce rate of your website to measure Reader Engagement. Bounce Rate is simply ...
Read more