What is shortcut to rename the spreadsheet name?

Asked by Last Modified  

34 Answers

Learn Microsoft Excel Training +1 Advanced Excel

Follow 3
Answer

Please enter your answer

Siva Ranjini

IT Trainer

ALT+H+O+R.
Comments
Dislike Bookmark

CA Asif Masani

Alt+H+O+R
Comments
Dislike Bookmark

Microsoft Certified in Analyzing and Visualizing Data with Excel

You have to press ALT then press O then H followed by R key on active sheet/spreadsheet of your workbook.
Comments
Dislike Bookmark

Excel | Access | Macro\VBA| SQL| SAS/Python/R | Trainer

Alt+H+O+R
Comments
Dislike Bookmark

Advanced Excel & PowerPoint Trainer

ALT +O+H+R
Comments
Dislike Bookmark

Trainer

Alt+I+c+r
Comments
Dislike Bookmark

Software Professional Trainer with 26+ years of Experience in Software Design and Development

You press ALT+O H R Rename the current sheet (Format menu -> Sheet submenu -> Rename command). To Switch one sheet to another sheet, use CTRL + PGUP or CTRL + PGDOWN
Comments
Dislike Bookmark

Excel, Advanced Excel and VBA Expert

Hello Umang, Shortcut to rename the current/active sheet is Alt+O, H, R(Firstly press hold Alt Key and then press the alphabet key "O". And you can release the Alt key, press "H" and then "R" keys. This will select you current sheet name. Then you can directly type the new name of your choice to the...
read more
Hello Umang, Shortcut to rename the current/active sheet is Alt+O, H, R(Firstly press hold Alt Key and then press the alphabet key "O". And you can release the Alt key, press "H" and then "R" keys. This will select you current sheet name. Then you can directly type the new name of your choice to the current sheet. read less
Comments
Dislike Bookmark

Microsoft Certified Expert I Author

HI Umang, To delete a sheet = ALT + E + L To rename a sheet = ALT + O + H + R
Comments
Dislike Bookmark

Go to the Spread sheet Name at the Bottom. Right Click on the Mouse. Now it will allow you to rename the sheet.
Comments
Dislike Bookmark

View 32 more Answers

Related Questions

Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
Hi Gary I might be able to help you please share your question with me and hopefully would be able to help you on the same.
Garry
0 0
5
My name is Kartik, I have 6 years of experience in Data analysis. I have experience on BI, Trackwise, Siebel and Oracle, Ms Access for fetching reports and for visualisation of data we use MS excel. Could please suggest me a certification or course, which can help me in career growth and to improve my skill set? I have a bent towards Analytics.
Hi Kartik, It is very good to know your experience in the field of Data Analytics. You just master those skills so that it is easy to sell your skill. I believe you are good at BIG DATA. If you possess...
Kartik
0 0
5

What is the use of Data validation commond. can you demonstare the example in common life?
The point of data validation is to pick the list in a drop down fashion. It will ease your work by allowing you to select the entries from the drop down rather than you writing for it. It saves a lot of time when it comes to large dataset.
Anil
0 0
5

Dear sir,how to convert number to text in excel by formula?
To get a range of time, you first need to convert the time in Text format and then merge them. You can use the following TEXT Formula: = TEXT( B4, “hh:mm” ) & ( ” – ”...
BINAYAK
0 0
8
How do you deal with large data sets in Excel?
if data rows are greater than 10L then u will use MS. Access
Ajay
0 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Excel basic Sessions Demo - Save a File

Vipin K

0 0
0
How to install Analysis ToolPak in Excel
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1....

Dheeraj

1 0
0
Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen Ma

0 0
0
Hidden Gems of MS Excel - Data Validation - Circle Invalid Data
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1
0
Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you