What is shortcut to rename the spreadsheet name?

Asked by Last Modified  

34 Answers

+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

I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.
As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team. VBA is for programmers who need to develop softwares. Learning VBA is like -...
Francis
0 0
View Comments5
Are there any VBA tutors around Secunderabad?
Tell me your requirement. I shall guide u online.
V
If we do course in VBA EXCEL, is these software is useful in USA? Because after completion of course I am flying to USA to pursue masters.
Yes definitely, Excel Vba is used everywhere despite of industry and geography...and it will definitely add value to your career and in your business also if u have...
Nanda
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V
How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.. within minutes it should come in my mind what code i have to write for this situation...I know its not that easy.. but I feel that its not hard too. I need advise as to what I have to do.. Eagerly waiting for the encouraging responses from all the teachers& trainers..
You need to understand the grammar of VBA Language first like collections ,objects ,methods and properties,syntax of different objects and their uses etc ..Once you are clear with these concepts ,you can...
Sandeep

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

Ask a Question

Related Lessons

Rand() Function
Purpose: Get a random number between 0 and 1. Return Value: Any decimal number between 0 and 1. Syntax: =RAND() Usage: RAND() function will returns a number between 0 and 1. For example, = RAND()...

Saburudeen Ma

0 0
View Comments0
VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0
View Comments0
Slicer in Excel
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...
R

Rakesh R

2 0
View Comments1
Excel Shortcuts
ShortCut Key Description F2 Edit the selected cell. F3 After a name has been created, F3 will paste names. F4 Repeat last action. For example, if you changed the color of text...

Afreen

0 0
View Comments0
Cell Properties
G

Gagan G.

0 0
View Comments0

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 Pune
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
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