Skip to main content

Most Important key board short keys of MS EXCEL

 

What are Most Important key board short keys of MS EXCEL?

Key board short keys of MS EXCEL  are two or more keys pressed together to perform an action which can also be done with your mouse.

Why do we use key board short keys of MS EXCEL?

As the name tells us that these are short keys, hence shortest way to perform an action which saves time.

short keys of MS EXCEL?

Here are some handy and useful short keys of MS EXCEL

Ctrl+W           to Close a worksheet 

Ctrl+O            to Open a worksheet 

Alt+H              to Go to the Home tab 

Ctrl+S              to Save a worksheet 

Ctrl+C              to Copy  text

Ctrl+V              to Paste already copied text 

Ctrl+Z              to Undo changes made   

Delete key       to Remove data in a CELL 

Alt+H                to Choose fill color 

Ctrl+X               to Cut the data (to paste somewhere else)

Alt+N                to Go to Insert tab 

Ctrl+B               to Bold the selected text font 

Alt+H, A, then C   to Center align cell contents 

Alt+P                  to Go to Page Layout tab 

Alt+A                  to Go to Data tab 

Alt+W                  toGo to View tab

Shift+F10             to Open context menu

Alt+H, B              to Add borders

Alt+H,D, then C  to Delete a column 

Alt+M                   to Go to Formula tab

Ctrl+9                   to Hide the selected row

Ctrl+0                    to Hide the selected column

Ctrl+arrow key     to Move to an edge of the current data in a worksheet

Ctrl+End         to Move to the last cell on a worksheet

Ctrl+Home      to Move to the A1 cell 

Ctrl+Page Up  to Move to the previous sheet in a worksheet

Tab              to Move one cell

Ctrl+T          to open the Create Table dialog

Ctrl+Y         Repeat the last command or action

Labels:

Popular posts from this blog

Top 100 completely Free & Open‑Source Tools for Developers and IT Students

Open‑source software empowers education by removing cost barriers and giving schools freedom to innovate. Here’s a curated list of 100 tools , divided into 10 categories , covering everything from school management to creative arts, coding, and cloud solutions. 🏫 1. School Management & Administration Moodle – LMS for courses, grading, and collaboration. OpenSIS – Student Information System. Fedena CE – ERP for admissions, exams, and timetables. OpenEduCat – Modular education management system. SchoolTool – SIS for small/medium schools. Chamilo – LMS with e‑learning focus. ILIAS – LMS for universities and schools. ATutor – Accessible LMS. Canvas LMS – Popular LMS platform. Open eSchool – SIS for K‑12. đź“š 2. Teaching & Learning Tools LibreOffice – Office suite. OnlyOffice – Collaborative office suite. GeoGebra – Math visualization. Anki – Flashcards with spaced repetition. Tux Paint – Drawing tool for kids. Scratch – Coding for beginners. Stellarium – Astronomy ...
Read more

What is freelancing and how to start earning Online as a beginner?

What is freelancing and How to start earning Online as a beginner? Free lancing means being independent, free to choose the workplace, free to choose the schedule and free to choose your wages. Everybody has to do something for living, a business or a job. Freelancing is in between business and job, it is like a business to provide paid services to your client or a customer. People now a days take this term for online jobs or some IT work only, but its not the same. You can provide any service from home or at your own workplace.   2.    What is difference between freelancing and remote jobs? Freelancing is providing your services for a project, you are totally responsible to complete that project in time, customer has nothing to do with your working hours or work place.   While remote job is employment where an employer hires you for some project and you are duty bound to work at your home or some workplace (remote) with a timetable and daily tasks given by...
Read more

How to avoid plagiarism in Ai generated Article and top 9 plagiarism detection tools ?

How to avoid plagiarism in Ai generated Article and top 9 plagiarism detection tools ? To avoid plagiarism  in Ai generated Article for a website or a blog , follow these guidelines: 1. Cite Sources Properly:    When using information, quotes, or ideas from other sources, provide proper citations. Follow the citation style (APA, MLA, Chicago, etc.) recommended by your institution or publication. 2. Paraphrase and Summarize:   Instead of copying verbatim, rephrase the information in your own words while maintaining the original meaning. Remember to cite the source even if you've paraphrased. 3. Use Quotation Marks:    When directly quoting a source, use quotation marks and provide an accurate citation. This indicates that the text is directly taken from another author. 4. Understand Plagiarism Policies:   Familiarize yourself with the plagiarism policies of your institution, organization, or platform. Different entiti...
Read more