Excel Shortcuts

Excel has so much functionality, but if you will notice you are doing some of the same things over and over. When you watch and advanced Excel user work, their hands fly across the keyboard maneuvering around the workbook doing various functions. Practice these shortcut keys and you will save time and impress your coworkers!

IMPORTANT Shortcut keys in Excel:

Keys	Description
CTRL +A	Selects the entire worksheet. If other worksheets in the workbook contain data, CTRL+A selects the active worksheet only.
CTRL+B	Applies or removes Bold formatting.
CTRL+C	Copies the selected range.
CTRL+D	Fill down command copies the contents, format & formula of the topmost cell of a selected range to the cells below.
CTRL+F	Opens the Find and Replace dialog box.
CTRL+G	Opens the Find and Replace dialog box with Go To tab selected.
CTRL+H	Opens the Find and Replace dialog box with Replace tab selected.
CTRL+I	Applies or removes Italic formatting.
CTRL+K	Opens the Insert Hyperlink dialog box for a new hyperlink.
CTRL+N	Creates a blank new workbook.
CTRL+O	Opens the Open dialog box to open or find a file.
CTRL+P	Opens the Print dialog box.
CTRL+R	Fill right command copies the contents, format & formula of leftmost cell of a selected range into the cells to the right.
CTRL+S	Saves workbook or opens Save As dialog box.
CTRL+T	Opens the Create Table dialog box.
CTRL+U	Applies or removes Underline formatting.
CTRL+V	Pastes cut or copied object, text or cell contents at the insertion point and replaces any selection.
CTRL+W	Closes the selected workbook.
CTRL+X	Cuts the selected range.
CTRL+Y	Repeats the last command or action.
CTRL+Z	Undoes the last command or action.
SHFT+SPACE	Selects entire row.
CTRL+SPACE	Selects entire column.
CTRL+SHFT+DOWN ARROW	Selects active cell to end of range in the column.
CTRL+END	Takes you to the last row of range.
CTRL+PgUp	Switches between worksheet tabs, from left-to-right.
CTRL+PgDn	Switches between worksheet tabs, from right-to-left.
CTRL+SHIFT+@	Applies the Time format with the hour, minute and AM or PM.
CTRL+SHIFT+:	Enters the current time.
CTRL+SHIFT+"	Copies the value from the cell above the active cell into the active cell or the Formula Bar.
CTRL+SHIFT+Plus (+)	Opens the Insert dialog box to insert blank cells.
CTRL+Minus (-)	Opens the Delete dialog box to delete the selected cells.
CTRL+;	Enters the current date.
CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+1	Opens the Format Cells dialog box.
CTRL+2	Applies or removes Bold formatting.
CTRL+3	Applies or removes Italic formatting
CTRL+4	Applies or removes Underline formatting.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL+0	Hides the selected columns.
CTRL+SHIFT+U	Switches between expanding and collapsing of the formula bar.
CTRL+ALT+V	Opens the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+ ARROW	Moves you to the edge of the region in the direction of the arrow you chose.

Request Quote by Email

*Required fields

Testimonials

I needed an Excel macro that had a lot of moving parts. Rob helped me spec out exactly what I needed, then delivered the exact functionality, on time. He's a professional.

Travis Van, ITDatabase

I have used ExcelAccessConsultant.com with great satisfaction for many years and continue to use their services. Their ability to efficiently and effectively devise elegant solutions to complex problems is unsurpassed in this space. I could not recommend EAC more highly.

Justin Barr , Managing Principal, Loan Workout Advisers, LLC.

The Access project ExcelAccessConsultant did for me was on time and exceeded the specifications.

Anonymous

(Access project) Rob does excellent work and is a pleasure to work with. He knows his stuff and is very thoughtful about putting solutions together to solve problems. Most importantly, he's extremely collaborative; I feel as though he is a true partner when we work on something together. I hope we get to work together again.

Bart Schwartz, Industrial Channel Research

ExcelAccessConsultant was awesome. I contacted them with my problem. They created a simply spread sheet with formulas that cut my work in half. This project was done in 1 day.

Kim Shower, Maximum Day Services

Excel Access Consultant always delivers a great product on time and within budget. They make sure the customer is happy with the end product. They make sure on the front end that the deliverables are clear so that no time is needed on the back end to correct formatting, calcs, etc.

Glen Casanova, Principal Consultant, Cobia Capital

Rob took the time to listen to my needs and work with me to understand my Access project. His work exceeded my expectations.

Dino Accettone, Accettone Funeral Home Ltd

I found EAC via Google search. In the search field I entered "Excel Guru" - enough said!

Genie Wood, Marketing Director, TBS Factoring Service

EAC has a thorough and professional-level understanding of Access reports. We will definitely call upon them with any of our Access needs.

Anonymous

EAC did a very good job and in a very timely manner. I would use ExcelAccessConsultant again and recommend them.

Anonymous

Rob did an excellent job customizing an Excel spreadsheet that meet our company's need to manage information. He was very responsive and delivered the product in a timely manner. We are very pleased with the entire process and the results. I will not hesitate to use Rob for the company's future needs.

Alex Leung, Artichoke Joe's Casino

VERY HELPFUL, MADE MY REPORT A LOT BETTER. VERY SATISFIED WITH HIS WORK.

Marc

I found Rob when searching the internet. During the project, I was always able to contact Rob directly (as advertised!) and the quality of his work and meeting time schedules exceeded my expectations. Rob is a true professional and I'm very pleased that I choose him for my excel project! Rob was a pleasure to work with and was very fair with billings--thanks again, Rob!

Darwin Brown, B4CRM

Excellent service and response time. I had a tight deadline and EAC was able to work with me to achieve the deadline.

Anonymous

The excel project worked better than I expected it could and made my client very happy.

Rita

Rob showed me he was extremely adept at writing some very difficult codes for a spreadsheet project I worked on.

Jay Jennings, North Texas Surfaces

I contacted EAC with a relatively small project, but needed it fast. They delivered quickly and even helped with a small revision quickly.

Tom

Rob listened to my needs and figured out a solution. His work was timely and he was always responsive. Excellent to work with.

John Kelly, Managing Director, Janney Capital Markets

EAC is customer focused and provides an excellent level of service. They are responsive and also highly capable. I highly recommend the services.

Tim

Rob was very responsive and made adjustments to the project due to some of the miscommunications on my end that made the project more complicated than needed. In the end, Rob sorted it out and we have a functional simple program that is saving us a significant amount of time. Thanks Rob!

Paul

We had a project which would have taken me days to create, I sent it to Rob over a holiday weekend and it was done when I came in the next morning.

Ryan

Responded quickly and accurately. Just what I needed.

Julie

On time . Nailed it first time. Extremely satisifed.

JR Fogarty, Managing Member, Paradise Enterprises, LLC

We needed help fast! We are a medical laboratory that tests 25% of this nation’s blood supply and are under strict FDA regulations for obvious safety reasons. Mr. Terry provided us with a swift, accurate system that not only performed as expected but continues to function. We automated tube the check-in process and Mr. Terry’s system checks every tube # for accuracy and duplication (average of 22,000 tubes per week). The system was supposed to be temporary but is still going strong 7 months later. I do not hesitate to recommend Mr. Terry. Not only did he respond quickly, he stayed around to make sure his work was appropriate for our needs.

Harry Felker, Database Administrator, Laboratory Information Management Creative Testing Solutions

Rob was great to work with. Understood my needs and delivered a solution to fit my needs.

Anonymous

Rob took the time to listen and fully understand what I was trying to accomplish, both tactically and strategically. He then came up with suggestions and executed the project in a timely and efficient manner. His support after the project was outstanding too!

Frank Weber, Ask Forensics

The answers to my questions were explained in a way that I could understand and the results were outstanding.

Wilfred Dennis

More Testimonials