You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them. Data in an Excel workbook can come from two different locations. The data may be stored directly in the workbook ...

Ctrl+Shift+N. Increase the paragraph indent. Alt+Shift+Right arrow key or the Tab key when at the beginning of a line. Decrease the paragraph indent. Alt+Shift+Left arrow key or Shift+Tab when at the beginning of a line. Align the paragraph to the left. Ctrl+L. Align the paragraph to the right. Ctrl+R.

Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets. To hide the sheet, select Hide. To unhide hidden sheets, select them in the Unhide dialog that appears, and then select OK . Press and hold CTRL, then click the items to select them.

Worksheet and workbook specifications and limits. 32-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. A data model’s share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded.

This article shows you how to automatically apply shading to every other row or column in a worksheet. Newer versions Web. There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.

If you use an Microsoft 365, Exchange, IMAP, or Outlook.com account, a copy of your mailbox is stored in an Offline Outlook Data File (.ost). To reduce the size of your Outlook Data File (.pst) or Offline Outlook Data File (.ost), you can manually compact the data file. Select your version of Outlook below to see instructions on how to reduce ...

Overview. Access and edit your files from all your devices. Share inside or outside your organization. Work together in real-time on Office documents. Quickly find the files that matter to you. Keep your files protected and backed up.

Add slide numbers or notes page numbers. On the View tab, in the Presentation Views group, click Normal. On the left of your screen, in the pane that contains the slide thumbnails, click the first slide thumbnail in your presentation. On the Insert tab, in the Text group, click Header & Footer. If you want to add slide numbers, click the Slide ...

In Word and PowerPoint, gridlines are for visual reference only and cannot be printed. If you want to print gridlines in Excel, see Print gridlines in a worksheet.. To show the gridlines, in Excel, PowerPoint, or Word, click the View tab, and then check the Gridlines box.. To hide the gridlines, clear the Gridlines check box.. More about tools that help you align and place text and objects:

Follow the steps below to reset your OneDrive app. 1. On your computer keyboard, press the Windows key and R at the same time to open the Run dialog box. 2. Copy or type wsreset.exe into the box then select OK . Note: A blank Command Prompt window will open and close briefly, then the Microsoft Store app will open.