Function in Microsoft Excel Spreadsheet
Ctrl + N
To create a new workbook.
Ctrl + O
To open a saved workbook.
Ctrl + S
To save a workbook.
Ctrl + A
To select all the contents in a workbook.
Ctrl + B
To turn highlighted cells bold.
Ctrl + C
To copy cells that are highlighted.
Ctrl + D
To fill the selected cell with the content of the cell right above.
Ctrl + F
To search for anything in a workbook.
Ctrl + G
To jump to a certain area with a single command.
Ctrl + H
To find and replace cell contents.
Ctrl + I
To italicise cell contents.
Ctrl + K
To insert a hyperlink in a cell.
Ctrl + L
To open the create table dialog box.
Ctrl + P
To print a workbook.
Ctrl + R
To fill the selected cell with the content of the cell on the left.
Ctrl + U
To underline highlighted cells.
Ctrl + V
To paste anything that was copied.
Ctrl + W
To close your current workbook.
Ctrl + Z
To undo the last action.
Ctrl + 1
To format the cell contents.
Ctrl + 5
To put a strikethrough in a cell.
Ctrl + 8
To show the outline symbols.
Ctrl + 9
To hide a row.
Ctrl + 0
To hide a column.
Ctrl + Shift + :
To enter the current time in a cell.
Ctrl + ;
To enter the current date in a cell.
Ctrl + `
To change the view from displaying cell values to formulas.
Ctrl + ‘
To copy the formula from the cell above.
Ctrl + -
To delete columns or rows.
Ctrl + Shift + =
To insert columns and rows.
Ctrl + Shift + ~
To switch between displaying Excel formulas or their values in cell.
Ctrl + Shift + @
To apply time formatting.
Ctrl + Shift + !
To apply comma formatting.
Ctrl + Shift + $
To apply currency formatting.
Ctrl + Shift + #
To apply date formatting.
Ctrl + Shift + %
To apply percentage formatting.
Ctrl + Shift + &
To place borders around the selected cells.
Ctrl + Shift + _
To remove a border.
Ctrl + -
To delete a selected row or column.
Ctrl + Spacebar
To select an entire column.
Ctrl + Shift + Spacebar
To select an entire workbook.
Ctrl + Home
To redirect to cell A1.
Ctrl + Shift + Tab
To switch to the previous workbook.
Ctrl + Shift + F
To open the fonts menu under format cells.
Ctrl + Shift + O
To select the cells containing comments.
Ctrl + Drag
To drag and copy a cell or to a duplicate worksheet.
Ctrl + Shift + Drag
To drag and insert copy.
Ctrl + Up arrow
To go to the top most cell in a current column.
Ctrl + Down arrow
To jump to the last cell in a current column.
Ctrl + Right arrow
To go to the last cell in a selected row.
Ctrl + Left arrow
To jump back to the first cell in a selected row.
Ctrl + End
To go to the last cell in a workbook.
Alt + Page down
To move the screen towards the right.
Alt + Page Up
To move the screen towards the left.
Ctrl + F2
To open the print preview window.
Ctrl + F1
To expand or collapse the ribbon.
To open the access keys.
Move to the next cell.
Alt + F + T
To open the options.
Alt + Down arrow
To activate filters for cells.
To edit a cell.
To paste a cell name if the cells have been named.
Shift + F2
To add or edit a cell comment.
Alt + H + H
To select a fill colour.
Alt + H + B
To add a border.
Ctrl + 9
To hide the selected rows.
Ctrl + 0
To hide the selected columns.
To cancel an entry.
To complete the entry in a cell and move to the next one.
Shift + Right arrow
To extend the cell selection to the right.
Shift + Left arrow
To extend the cell selection to the left.
Shift + Space
To select the entire row.
Page up/ down
To move the screen up or down.
Alt + H
To go to the Home tab in Ribbon.
Alt + N
To go to the Insert tab in Ribbon.
Alt + P
To go to the Page Layout tab in Ribbon.
Alt + M
To go to the Formulas tab in Ribbon.
Alt + A
To go to the Data tab in Ribbon.
Alt + R
To go to the Review tab in Ribbon.
Alt + W
To go to the View tab in Ribbon.
Alt + Y
To open the Help tab in Ribbon.
Alt + Q
To quickly jump to search.
Alt + Enter
To start a new line in a current cell.
Shift + F3
To open the Insert function dialog box.
To calculate workbooks.
Shift + F9
To calculate an active workbook.
Ctrl + Alt + F9
To force calculate all workbooks.
Ctrl + F3
To open the name manager.
Ctrl + Shift + F3
To create names from values in rows and columns.
Ctrl + Alt + +
To zoom in inside a workbook.
Ctrl + Alt +
To zoom out inside a workbook.
Alt + 1
To turn on Autosave.
Alt + 2
To save a workbook.
Alt + F + E
To export your workbook.
Alt + F + Z
To share your workbook.
Alt + F + C
To close and save your workbook.
Alt or F11
To turn key tips on or off.
Alt + Y + W
To know what's new in Microsoft Excel.
To open Microsoft Excel help.
Ctrl + F4
To close Microsoft Excel.
TL;DR: The 2022 Complete Microsoft Excel Expert Bundle is on sale for £29.55, saving you 99% on list price.
If you’re spending any time in the professional world, you’re probably going to have to learn to use Excel. Becoming familiar with tools like Excel isn’t just learning one software for one workplace. Like Word, Excel is a multi-functional tool you can put to a wide variety of uses, just as long as you know how.
Whether you’re learning for a job or by your own motivation, The 2022 Complete Microsoft Excel Expert Bundle can help you get started and possibly carry you all the way to the master level. Normally, The 2022 Complete Microsoft Excel Expert Bundle would cost you around £4,000, but for a limited time, it’s on sale for £29.55.
Even if you’ve switched fields recently, one of the things that probably stayed the same is a requirement of some basic Excel skills. That’s where this bundle starts, with “Microsoft Excel 2021/365: Beginners Course” as an entry point that it quickly moves beyond.
From there, dive into some more advanced Excel functions and commands. After that, you can start learning some of the tools that ultimately lead to using Excel as a way to automate simple, repetitive tasks. If any significant portion of your job requires finding information and entering data, “Macros & VBA for Beginners” and “VBA for Beginners” may have some exciting information for you.
This bundle packs more than 70 hours of Excel instruction into one self-paced package. It may be intimidating at first, but setting your own pace and sticking to it can actually be better for your learning than a traditionally-structured class.
Usually The 2022 Complete Microsoft Excel Expert Bundle costs £4,000, but for a limited time it’s on sale for £29.55.
Opens in a new tab
Opens in a new tab
2022 Complete Microsoft Excel Expert Bundle (opens in a new tab)
£29.55 at the Mashable Shop
(opens in a new tab)
Microsoft has moved to reassure users of the Microsoft 365 Apps for enterprise suite that its decision last week to rollback new cyber security measures blocking the use of Visual Basic for Applications (VBA) by default macros is a temporary measure, and the policy will be reenacted in the near future.
The reversal of the blocking policy – which was implemented to better protect Office users, particularly remote ones, from inadvertently downloading malware by throwing extra layers of security in their way – caught users by surprise, with many frustrated that the change was not communicated to them.
The rollback also caused confusion in the security community, as the policy appeared to have been working quite well, with threat actors forced to switch up their campaign tactics because it was becoming less effective to simply spam users with tainted .docx or .xlsx files.
Redmond has now responded to the questions raised by the rollback, and revealed that it took the decision to suspend the policy while it makes some needed tweaks.
“Following user feedback, we have rolled back this change temporarily while we make some additional changes to enhance usability,” a Microsoft spokesperson told Computer Weekly in comments emailed on 11 July.
“This is a temporary change, and we are fully committed to making the default change for all users,” they added. “Regardless of the default setting, customers can block internet macros through the Group Policy settings described in this article.
“We will provide additional details on timeline in the upcoming weeks.”
As the above-linked article makes clear, it is still perfectly possible to block VBA macros in Microsoft 365 Apps for enterprise, but until Microsoft reverts to blocking by default, this feature will need to be implemented by admins.
Microsoft does recommend blocking macros from running in Office files from the internet as part of the security baseline for Microsoft 365 Apps for enterprise, and broadly speaking, admins should do so for most users, making exceptions only in very specific circumstances.
Admins will need to enact blocking separately for each of the five applications that were in scope of the policy by navigating to the Group Policy Management Console under User Configuration\Policies\Administrative Templates.
For Access, this will be Microsoft Access 2016\Application Settings\Security\Trust Center; for Excel, Microsoft Excel 2016\Excel Options\Security\Trust Center; for PowerPoint, Microsoft PowerPoint 2016\PowerPoint Options\Security\Trust Center; for Visio, Microsoft Visio 2016\Visio Options\Security\Trust Center; and for Word, Microsoft Word 2016\Word Options\Security\Trust Center.
Alternatively, admins can use the VBA Macro Notifications Settings to manage how macros are handled by Office. Doing so will prevent users from being lured into enabling malicious macros by displaying a Trust Bar with a warning that macros are present but disabled. Users will still be able to inspect and even edit files, but can’t use any disabled functionality without clicking through to enable that on the Trust Bar, in which case the file will be added as a Trusted Document, and macros allowed to run. This policy can be enabled across the five in-scope applications by navigating to the same locations as listed above.
Note that these policies only apply to Microsoft 365 Apps for enterprise, not Microsoft 365 Apps for business.
More information on Microsoft’s VBA macros policy can be found here.
DALLAS, Tx. – A Dunbar High School student has just become the school’s first two-time Microsoft Office Specialist U.S. National Champion.
Andrew Chuang Saladin took the top prize in the Microsoft Excel (Office 2016) competition.
The Microsoft Office Specialist National Online Championship is a competition that tests students skills on Microsoft Office Word, Excel and Powerpoint. This year, 44,000 students, ages 13 to 22, competed in one of six competition tracks.
Saladin was one of 85 finalists that competed in the National Championship in Dallas, Texas.
Finalists were given a printed copy of a document, spreadsheet or presentation to recreate along with printed instructions and digital assets. They were scored based on the accuracy of the recreation compared to the original.
“I am grateful that I was given this opportunity to travel, have fun, and compete for something I am passionate about,” said Saladin. “Of course, the prizes are appealing but above all, being chosen to represent my school and build on its legacy is something really special for me.
This is the second national championship for Saladin. In 2021, he was the state, national and world champion in Powerpoint (2019).
PREVIOUS STORY: Dunbar High School student wins Microsoft World Championship
He will now get the opportunity to compete in the 2022 MOS World Championship happening in Anaheim, California later this month. There he will compete with dozens of other finalists from around the world.
Since 2011, Dunbar High School has developed 29 state champions, seven national champions and three Microsoft World Champions.
TL;DR: A lifetime license of Microsoft Office Home and Business for Mac 2021 (or for PC) is on sale for £33.41, saving you 89% on list price.
Microsoft Office is an essential digital toolbox for many folks who work from home. Word and Excel are basically the bread and butter of the business world, so having them installed on your computer is a smart idea.
You could subscribe to Office 365, which involves paying a monthly or annual fee — but most of us are already paying for too many subscriptions. Fortunately, Microsoft offers another option: a lifetime license. That means you pay once and get the entire suite of apps for life on one computer. And from now until July 14, you can secure that perpetual license to Microsoft Office Professional 2021 for its lowest price ever — just £33.41.
A lifetime license gets you access to the Office 2021 versions of Word, Excel, PowerPoint, Outlook, Teams, OneNote (the Windows package also includes Publisher and Access). You’ll receive license keys for each platform immediately upon purchase, as well as obtain links for quick setup. You’ll need a minimum of 4GB RAM and 10GB hard disk space available for the Mac version and just 1GB of RAM and 4GB of disk space available for Windows. Once installed, you can start drafting up documents, analyzing data, sharing files with your team, setting up video meetings, and more.
So, what’s the catch? With a lifetime license, you’ll get security updates every few months, as well as free customer service assistance for life. You won’t, however, get access to all the features Microsoft offers subscribers each month, and, crucially, the license is for one computer only. But if you’d rather not deal with another subscription and just need the basics, it’s still worth it for the value.
Get the entire Microsoft Office Professional 2021 suite for Mac or PC for only £33.41 — that’s an 89% discount and less than the last time we featured it. The promotion only lasts until July 14, though, so hop to it!
Opens in a new tab
Opens in a new tab
Microsoft Office Home and Business for Mac 2021 (or for PC) (opens in a new tab)
£33.41 at the Mashable Shop
(opens in a new tab)
Microsoft appears to have quietly, and without fanfare, reversed a February 2022 policy to block Visual Basic for Applications (VBA) macros by default across five of the most used Office applications, citing negative user feedback.
The new policy was initially introduced on the basis that by making it impossible for users to enable macros by clicking a button by throwing extra click-throughs and reminders in their path, it would make it harder for threat actors to trick them into opening malicious attachments containing malware payloads. The change was made at least in part because of the ongoing prevalence of remote working.
However, as first reported by Bleeping Computer, Redmond now appears to have put the brakes on the policy and begun a rollback – which may yet prove temporary.
The rollback was first spotted by Microsoft users puzzled as to why the old security warning had reappeared on documents containing VBA macros, as opposed to the new block notice that they were becoming used to.
UK-based user Vince Hardwick was first to query the change on Microsoft’s Tech Community forums after running into difficulties attempting to demonstrate the new policy for a YouTube video he was making.
Responding to Hardwick’s query on the forums, Angela Robertson, Microsoft 365 Office Product Group principal GPM for identity and security, said: “Based on feedback received, a rollback has started. An update about the rollback is in progress. I apologise for any inconvenience of the rollback starting before the update about the change was made available.”
Other users, including Hardwick, voiced frustration that Microsoft had failed to communicate the rollback to them.
The nature of the feedback that Robertson referred to is unclear, but if the decision to rollback is indeed based on user feedback, it is unlikely to be the feedback of the security community, which had generally welcomed the move in the hope that it would Boost organisational security by cutting off an easy way for cyber criminals to establish initial access into their targets, ie by emailing them malicious documents or spreadsheets.
Security experts have already responded, describing Microsoft’s move as a “terrible idea” and a “weird decision”:
In the short period since the change began to roll out, plenty of evidence has indeed stacked up that the change was forcing threat actors to evolve their tactics, techniques and procedures (TTPs).
At the end of April, Proofpoint reported that the group behind the Emotet botnet had turned to using tainted OneDrive URLs instead of macro-enabled attachments, likely because blocking macros by default makes it harder for the average user to fall for the trick.
Then in June, Check Point reported that the Snake Keylogger was shooting back up its monthly threat charts following a number of novel email campaigns that saw it distributed in a tainted PDF file – historically, Snake had arrived in Word documents or Excel spreadsheets.
Computer Weekly contacted Microsoft to seek further clarification on the nature of the rollback, but had not received a response at the time of writing.
AppleInsider is supported by its audience and may earn commission as an Amazon Associate and affiliate partner on qualifying purchases. These affiliate partnerships do not influence our editorial content.
The Prime Day Microsoft for Mac deal is back, with an 88% exclusive discount dropping the price down to $39.99 for AppleInsider readers.
This weekend only Extended through Monday, July 18, AppleInsider readers can take advantage of a bonus 20% price drop on a lifetime Microsoft Office for Mac Home & Business 2021 license, bringing the cost down to $39.99. Or if you're a Windows user, pick up Microsoft Office Professional 2021 for Windows for the same $39.99 price. The 88% discount is the best we've seen on the popular software.
The Microsoft Office Home & Business 2021 license for Mac includes access to:
The Microsoft Office Professional 2021 license for Windows includes access to:
AppleInsider and Apple Authorized Resellers are also running specials on Mac and iPad hardware that will not only deliver the lowest prices on many of the items, but also throw in bonus savings on accessories, software and more. Here are just a few of the deals going on this weekend: