AuthorGreg ArchivesCategories |
Back to Blog
Using A Pc Keyboard With A Mac For Excel10/19/2021
Using any of these shortcuts will either apply or remove the formatting from the selected text or, if no text is selected, the formatting is applied to any text that is typed after. They can be used to stylize, emphasize, or add functionality to your written content.The three most popular formatting options for style and emphasis are italics (Ctrl+I), bold (Ctrl+B), and underlining (Ctrl+U). Although the examples given are for Windows, most of these also work on Mac if the control key is substituted for the command key:Let’s get more specific! Some of these shortcuts will still work across Excel and PowerPoint too, but they are related to inputting text.After that, you’ll most likely want to return to normal formatting for the main body of your text, in which case you can align left with Ctrl+L. Alternatively, you can press Shift+F3 to cycle through three styles: upper case, lower case, and lower case with the first letter of the sentence in capsDo you need text right in the middle of the page for a title? You can center text with Ctrl+E. There’s no need to delete it all and type it out again: just highlight the relevant text and press Ctrl+Shift+A to turn it all lower case/upper case. Or you might just have typed out a whole paragraph with caps lock on, and now it looks like you’re screaming.
![]() ![]() Using A Pc Keyboard With A For Excel Mac If TheCtrl+F is also extremely useful in web browsers and across the Office suite. A dialog box will appear for you to input the web address that the text is to be linked to, and once you’ve entered the information, the selected text will turn into a blue, underlined hyperlink that can be clicked to visit the assigned web page.Are you trying to find a specific section in a long document? Hit Ctrl+F for Find, allowing you to enter the word or phrase that you’re looking for and be taken directly to it. Highlight a word or sentence that you want to link to a webpage and press Ctrl+K. And if you want to tidy your document up by having the beginning and end of every line aligned neatly with your margins, you can justify with Ctrl+J.This one is handy in a number of situations – not just in Word, but also in PowerPoint and Excel, as well as in most online CMS editors. Ti 92 emulator macIf the next cell is blank, the selection is extended to the next non-blank cell.Navigate to the bottom, top, left corner, or right corner of the current data region, depending on which arrow you press. Shift+Space selects an entire row, while Ctrl+Space selects an entire column.This extends the selection of cells to the last non-blank cell in the same column or row as the active cell. But there are a few Excel-specific shortcuts that will speed up your spreadsheet productivity.In addition to the Shift+Arrow key method described above, Excel also has a couple of convenient functions for selecting larger areas of the spreadsheet. Shift+Up/Down will also select entire lines, but once you want to select more than a paragraph at a time, you may find using the mouse is the more productive method.Pressing Ctrl+Shift+G will instantly bring up your word count to provide you with that all-important visual affirmation that you are, indeed, moving steadily towards your goal.Read next: Your Office 365 Implementation Checklist – How to plan the switch Shortcuts for ExcelAs mentioned previously, many of the above will also work in Excel. Shift+Left/Right will highlight one character at a time, Shift+Alt+Left/Right one word at a time, and Shift+Ctrl+Left/Right an entire line at a time. ![]() Make your own shortcuts!Did you know that you can take your efficiency to the next level by creating your own personal keyboard shortcuts? You can navigate to the relevant menu with keyboard shortcuts: press Alt+F to open the File Menu, then T to open the options. For example, HotKeysList shows you a comprehensive list of your shortcuts and allows you to manage, add more, or change the formulas you have. What are the main Windows shortcut keys?Aside from program-specific ones, there are several shortcuts which are helpful for navigating the Windows interface.The main key for a lot of shortcuts in this area is the Windows logo key! Some of our favorite examples are maximizing the current window you have open through using the Windows key, F11 + the Up arrow, switching between the applications you have open at a given moment through using the Windows key + D, ensuring security by locking your screen whenever you leave your computer by combining the Windows key + L, or finally, quickly shutting down your computer at the end of a long day with the Windows key + X.Have you lost track of all the shortcuts we’ve mentioned here? Don’t worry – there are various programs that allow you to view all the keyboard shortcuts, or hotkeys, which are available on your device. Zoom out again with the – key.
0 Comments
Read More
Leave a Reply. |