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

Youtube Creative Commons (CC) क्या होते हैं और इनका इस्तेमाल कैसे करें

क्रिएटिव कॉमन्स (Creative Commons (CC) | Youtube Creative Common Video Kya Hote Hain - Janiye Hindi Me | Creative Common Videos का इस्तेमाल कैसे करें Rohit Maan Posted by Rohit Maan 10/04/2020 Creative Commons On youtube in hindi guide guruji दोस्तों सामान्यतः यूट्यूब पर जो सामग्री होती है, उसका इस्तेमाल कोई भी दूसरा व्यक्ति फिर से नहीं कर सकता है ओर ऐसा करना यूट्यूब की पॉलिसी के खिलाफ होता है और अगर आप यूट्यूब की किसी भी सामग्री को कॉपी करके फिर से यूट्यूब पर डालते हैं तो उसका ओरिजिनल मालिक आपके खिलाफ कॉपीराइट स्ट्राइक लगा सकता है और इसके चलते Youtube आपके चैनल को ब्लॉक कर सकता है। लेकिन यूट्यूब पर कुछ ऐसी सामग्री भी उपलब्ध हैं, जिनको आप इस्तेमाल कर सकते हैं और आपके खिलाफ कोई भी कॉपीराइट क्लेम नहीं आएगा। youtube की ऐसी सामग्री को Creative Commons सामग्री कहते हैं। जी हाँ दोस्तों, यूट्यूब पर उपलब्ध Creative Common वीडियो या सामग्री को आप डाउनलोड करके फिर से अपने चैनल पर कैसे भी इस्तेमाल कर सकते हैं और आपके खिलाफ ऐसा करने से कोई भी कॉपीराइट स्ट्राइक भी नहीं आएगा। Youtube पर उपलब्ध Creat...
Post a Comment
Read more

Details overview of Busy Software

Download the latest versions of Busy Desktop, Busy Mobile App, Busy Agent, Busy BNS, Migration of Data from Tally to Busy, Formats for GST Data Upload, Sample Data and other related resources to help you get started with and usage of Busy Accounting Software. BUSY 21 Release 10.0 (Latest Release) of Busy Accounting Software – India’s No.1 GST Accounting Software file_download Download Busy 21 Release Notes Statutory Updates Archives BUSY 21 (Rel 9.7) file_download BUSY 21 (Rel 9.6) file_download BUSY 21 (Rel 9.5) file_download BUSY 21 (Rel 9.4) file_download BUSY Online Client Latest Release – Most Secure Online Accounting On Cloud file_download Download Busy Online Client BUSY Mobile App Download the latest version of BUSY Mobile App, which gives Busy Desktop Software Customers access to 100+ reports related to Sales, Purchases, Receivables, Payables, Stock and much more. The app also allows you to create and share receipts, invoices, orders and quotations with ease   BUSY BNS Dow...
Post a Comment
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