Excel Shortcut Keys Tips for the Excel Experts
Excel, like any great software, has many excellent keyboard shortcuts. Here are some of the best.
Ctrl+; —Inserts today's date.
Ctrl+Shift+:—Inserts the current time (the colon is what is in a clock reading, like 12:00).
Ctrl+Shift+#—Changes the format of a date.
Ctrl+5—Applies a strikethrough to the text in a cell.
Ctrl+0— Hides the current column.
Ctrl+9—Hides the current row.
Ctrl+F6—Switches between open workbooks (that is, open Excel files in different windows).
Ctrl+`—That's the accent mark, up by the 1 key. This combo toggles the view in the sheet to show all the formulas.
Ctrl+PageUp or PageDown—Quick shift between the sheets in the currently open workbook.
F2—Start editing the current selected cell (much faster than double-clicking).
Shift+F10—Opens the right-click menu for the cell you're in.
Microsoft Excel is the world's most popular spreadsheet application. Rapid application Excel VBA solutions show an immediate return on investment. You do not have to implement or pay for new software and can easily integrate with your existing systems.
We solve problems quickly and efficiently, with minimal disruption to your company and you. In addition, when appropriate, we will provide training so your employees can solve their individual problems on their own. Our Excel Consultants can run Excel Clinics to cover specific issues for your employees.
Contact Xlteq to find out how you can get the most out of Microsoft Excel.
Excel Development Projects
A leading Auctioneer came to xlteq to help streamline and automate their global headcount reporting in Excel. This included real-time clarification of total headcount coupled with detailed location status functionality.
A Danish financial services company asked our Excel Consultants for support with preparing their client investment portfolios. This task now takes less than a minute per customer and is delivered in a format selected by the client then presented as a visually effective Investment Portfolio Dashboard.