Microsoft 365 Family and McAfee Total for 76.99 instead of 188.95 euros
Microsoft Excel: Your own standard template
Tired of using the same font and cell size over and over again? Then create your own template! Open over file and New a new spreadsheet and take the necessary time to adjust the desired parameters. Now save that over F12 on your PC and select “Excel Template” as the file type. To open the template in the future, click Newabove the Office Templates Personally and then twice on your desired template.
Microsoft Excel provides a better overview with format templates.
Microsoft Excel: Better overview – and smarter
So that your efforts to create a clear table don’t end up in a black and white jumble of numbers, Excel offers simple ways to visually enhance your tables or highlight important data. Under begin and the “Format templates” ribbon, you can make your table more attractive with just one click. For example, under “Welcome to Excel” there is “Create a list”, which will help you with the same intention, or under “Personal Budget” there is a budget and much more. Under “Conditional Formatting” you can create color accents, symbols, data bars or your own rules. For example, to mark all test grades worse than 3.0 in red, click on Conditional formatting, Rules for highlighting cells and up greater than. Enter 3.0 in the free field and confirm by clicking on OK.
Excel: Split cell contents into multiple columns
Do you want to create a table that contains names and addresses, but which are not divided into their own, i.e. separate columns? No problem! For example, to split first and last names from one cell into two new cells, open the file in question. Mark the cells you want to separate by clicking. Then use the function text in columns Under the menu item Data. A click follows widthright Now determine the separator that stands for the beginning of a new cell. Tick ”Spaces” and “Consecutive …” and confirm with further as Complete. Wherever there were previously spaces in the marked area, the next word now begins in a new cell. Should the table now be sorted by last name? You mark everything, press sort by and select the last name column for “Sort by”.
Microsoft 365 Family and Norton 360 Deluxe for 76.99 instead of 183.99 euros
Microsoft Word: The most important keyboard shortcuts
Many activities in Microsoft Excel can be completed faster thanks to keyboard shortcuts (hotkeys). Here is an overview of the most commonly used:
- F2 starts the editing mode to fill the cell. ESC click to exit.
- Ctrl + Page Up/Down switches between the spreadsheets.
- Ctrl + Shift + . inserts the current time.
- Alt+Shift+= calculates the car total.
- Ctrl + . inserts the current date.
- Ctrl + + inserts empty cells or columns.
- Ctrl + – deletes cells or columns.
- Shift+F2 opens the comment function of the selected cell.
- Ctrl + arrow key lets the cursor jump to the first or last cell in the pressed direction.
- Ctrl + Shift + Arrow Key selects all cells or columns.
Microsoft Excel: Use Office advantages
Whether Word, PowerPoint or Excel – once registered, you have a free 5 GB cloud. With that you can use the buttons file and Share in real time work with friends and colleagues on the same document and perfect it anytime, anywhere. It doesn’t matter whether you work with a smartphone or computer. You can even integrate an Excel spreadsheet into Word and still edit it in Excel. You copy the table and click below in Word Insert on paste contentinsert shortcut and Microsoft Excel workbook object as OK.
Microsoft Excel: Remove Duplicates
If the worksheet is shared with other people over a long period of time, it can happen that some entries exist twice or three times. To get rid of the superfluous data in a flash, mark the desired area and select below Data the point remove duplicates. Confirm the column selection with OK and – lo and behold – everything is only available once.
Microsoft Excel: Expand status bar
To display useful information about cells, right-click to expand your status bar at the bottom edge of the screen. Sum, mean value or the number of entries are optionally set at the factory. Other useful hints are about the “Numerical number”, “Maximum”, “Minimum”.
Excel: Preferably in the horizontal
Have you created a table and found that a horizontal orientation is better than a vertical one? You mark the area you want, copy the content to the clipboard and right-click in a new cell. Now select the paste option with the double arrow image Transpose. The case is already closed.