Excel’s New Keyboard Shortcut Can Paste Without Formatting
Recall an Email in Outlook on Desktop
How to Use the IF Function in Microsoft Excel
How to Remove Dotted Lines in Microsoft Excel
Have you ever been working on an Excel spreadsheet when dotted lines suddenly appeared? While fine to some, those dotted lines may be distracting to others. We’ll show you when and why these dotted lines appear and how to remove them.
There are a few instances where you may see dotted lines in Excel. If you set up your sheet to print or use the Page Break Preview, you’ll see dotted lines for page breaks when you return to the Normal view. Additionally, if you share a spreadsheet with editing privileges, a collaborator may add a border with a dotted line style.
[mai mult...]Printing a Specific Selection of Cells in Microsoft Excel
This option is the quickest method to print a selected range of cells. Select and highlight the range of cells you want to print.
Next, click File > Print or press Ctrl+P to view the print settings.
Click the list arrow for the print area settings and then select the “Print Selection” option.
The preview will now show only the selected area. Click “Print” to finish the process.
Setting the Print Area in Microsoft Excel
- If you print the selected area frequently, you can set the selected range as the print area. This option will save you from needing to select the range each time you print.
- Select the range of cells you want to set as the print area. Next, click Page Layout > Print Area > Set Print Area.
- The print area is now set.
- The next time you print (File > Print or press Ctrl+P), this area will be printed by default.
- To remove a print area, click Page Layout > Print Area > Clear Print Area.
How to Freeze Multiple Rows in Microsoft Excel
Freezing a single row is easy, but what if you want to freeze multiple rows at the top of your Microsoft Excel spreadsheet? Once you freeze your rows, those rows will stick to the top of your spreadsheet and won’t move when you scroll down your spreadsheet.
[mai mult...]How to Go Frame by Frame in VLC Media Player
If you’d like to play your video one frame at a time, use a built-in VLC Media Player feature to do that. You can use a keyboard shortcut as well as an on-screen button to move one frame at a time in your video.
[mai mult...]How to Search Within a Google Drive Folder
If you store a lot of files in Google Drive, you’ve likely had to search for one at some point. But if you know your item is in a particular folder, you can save time by limiting your search to that folder.
- First, you can quickly search inside of a folder without opening the Google Drive search tool. If you don’t immediately find what you need, you can use advanced search techniques to narrow your search within that folder as well.
How to Rearrange Pages in Microsoft Word
Think a page belongs somewhere else in your document? If so, Microsoft Word offers a couple of ways to change the location of your pages. You can rearrange your pages using either the Navigation Pane or cut and paste.
[mai mult...]