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...]

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.

[mai mult...]

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...]

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.

[mai mult...]

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...]

[mai mult...]