Entering & Editing Data in Excel 2011

View:  
Sorted by:  

Check Spelling and Grammar in Office 2011 for Mac

Thankfully, Office 2011 for Mac can help you fix most spelling errors. Don’t let that make you think you don’t have to do any checking of your own, though, because even Microsoft Word’s advanced grammar [more…]

Office 2011 for Mac: Insert and Delete Excel Cells, Rows, Columns

Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button: [more…]

How to Select Worksheet Cells in Excel for Mac 2011

When working in an Excel spreadsheet or workbook in Office 2011 for Mac, click a cell to select it. Excel for Mac 2011 will indicate the selected cell in several different ways: [more…]

Editing and Clearing Worksheet Cells in Excel for Mac 2011

When you start typing in a cell in Excel in Office 2011 for Mac, the border gets a nice, soft shadow and seems to be closer to you than the rest of the sheet. The blinking insertion cursor displays inside [more…]

Office 2011 for Mac: Applying Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [more…]

Identifying Cursors in Excel in Office 2011 for Mac

Excel for Mac 2011 is always trying to tell you what it can do. When you’re in a worksheet, the cursor changes as you move the mouse around. The cursor’s appearance reveals what you can do: [more…]

Excel for Mac 2011 Worksheets: How to Drag a Series of Typing

In Office 2011 for Mac, Excel is pretty smart, because it can automatically fill in a series of either numbers or dates. Excel for Mac 2011 can even make intelligent guesses about a series of numbers. [more…]

Office 2011 for Mac: Using the Custom Lists Feature in Excel

The Custom Lists feature is about making lists that Excel for Mac 2011 can refer to when filling in a series by dragging a selected cell’s fill handle [more…]

How to Type a Formula Manually in Excel for Mac 2011

Cell formulas are equations that perform calculations or logical operations. In Excel in Office 2011 for Mac, you can enter a formula on your own, or you can use the Formula Builder. When learning to type [more…]

Let Excel for Mac 2011 Type a Cell Formula for You

Cell formulas are equations that perform calculations or logical operations. In Excel for Mac 2011, you can enter a formula on your own, or you can use the Formula Builder, which helps you build formulae [more…]

Using Built-In Functions and Arguments in Excel for Mac 2011

In Office 2011 for Mac, Excel has hundreds of built-in functions that you can use in cell formulas. While you type a function in a cell formula, a pop-up menu appears. The following example uses Excel’s [more…]

Excel for Mac 2011: Create Formulas with the Formula Builder

Excel’s Formula Builder in Office 2011 for Mac is a tool in Toolbox designed to help you build cell formulas. You start at the top of the Formula Builder and work your way down to put a finished cell formula [more…]

Excel for Mac 2011: Make Relative References on Worksheets

Copying and pasting cells and cell formulas works differently from text and other objects in Excel in Office 2011 for Mac, so they can be a little bit puzzling if you don’t know the secrets about references [more…]

Office 2011 for Mac: Apply Number and Text Formats in Excel

One of the things you might find you do frequently in Excel 2011 for Mac is change the way cells look, and you do so with options on the Home tab of the Ribbon. Other than the visual effect, format also [more…]

Excel for Mac 2011: Fit and Position Cell Content in Worksheets

You can align and position cell contents in Excel using the Alignment group on the Office 2011 for Mac Ribbon’s Home tab at the top of the Excel window: [more…]

Office 2011 for Mac: Format Cell Borders in Excel Worksheets

Formatting cells and cell ranges in Excel 2011 for Mac is like formatting tables. In the Font group of the Ribbon’s Home tab, clicking Borders button displays a drop-down gallery of border styles. [more…]

Office 2011 for Mac: Format Dates and Times in Excel

Excel 2011 for Mac has fantastic date and time calculation capabilities. When using Excel worksheets, you need to know just two secrets: Each day is represented by a whole number, called a [more…]

Office 2011 for Mac: Choosing Conditional Formatting Rules in Excel

You can set Excel 2011 for Mac to change the format of a cell, cell range, table, or pivot table based on conditions you specify. Use these settings when you want a cell’s appearance to change as the result [more…]

Excel 2011 for Mac: Using the Paste Special Feature

In Office 2011 for Mac, Excel’s simple Paste option handles most of your ordinary pasting requirements, but it's a one-shot deal — you can choose only a single option. On the other hand, the Paste Special [more…]

Move and Copy Entire Excel Sheets in Office 2011 for Mac

In Excel 2011 for Mac, you can move or copy one sheet at a time, or select multiple worksheets and move or copy them all at once. You can move or copy sheets within a workbook or from one workbook to another [more…]

Using the Excel Camera Tool in Office 2011 for Mac

The Camera tool in Excel 2011 for Mac creates a “picture” of a range of cells. “Picture” is in quotation marks because these pictures aren’t static; they’re [more…]

Hide and Unhide Excel Worksheets, Rows, and Columns in Office 2011 for Mac

In Excel 2011 for Mac, you can hide entire worksheets or just some columns or rows. And you can unhide them, too. This control over what can be seen or not can be helpful in hiding content such as: [more…]

How to Move Data from External Sources into Excel 2011 for Mac

You can find data in many different places and bring it into Excel 2011 for Mac workbooks in whole, or as the result of a query in a query table. The tools on the External Data Sources group of the Data [more…]

Using a Web Query to Load Tables in Excel 2011 for Mac

In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. A Web query is simple: It’s just a Web-page address saved as a text file, using [more…]

Advertisement

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com