Excel 2007: Create a Spreadsheet

TL;DR

Learn how to create a new Excel spreadsheet, insert text, create columns and navigate through the workbook.

Transcript

Let's jump right in and start creating our first Excel spreadsheet. When you first open Excel, the software opens to a new, blank workbook. If you already have a spreadsheet open and want to create a new one, just click the Microsoft Office Button and select New. The New Workbook dialog box opens. Blank document is highlighted by default, so go ahe... Read More

Key Insights

• 🤗 Excel opens to a new, blank workbook ready for creating spreadsheets.
• 🤨 Cells in Excel have names or references based on their column and row.
• 🤩 Navigating through Excel can be done using the Tab key, arrows, or mouse.
• 🤩 Columns can be created by typing text in cells and using tab or arrow keys to move to adjacent cells.
• 💾 Microsoft Office Button provides options for saving and naming workbooks.
• 👻 Excel allows for saving files in different formats for compatibility with different versions of Excel.
• 🧘 Edits and changes to text can be made directly in the formula box.

Questions & Answers

Q: How do I create a new Excel spreadsheet?

To create a new Excel spreadsheet, open Excel and click the Microsoft Office Button, then select New.

Q: What are cells in Excel?

Cells in Excel are the little rectangles where your text appears. Each cell has a name or reference based on its column and row.

Q: How do I insert text in Excel?

Select the desired cell, type your text, and press enter. The text will appear in the cell and the formula box.

Q: How can I navigate through an Excel spreadsheet?

You can move from cell to cell using the Tab key, the arrows on your computer, or by selecting a specific cell with your mouse. The Page Up and Down buttons help you navigate the spreadsheet.

Summary & Key Takeaways

• Open Excel and create a new, blank workbook by clicking the Microsoft Office Button and selecting New.

• Cells are the little rectangles where your text appears, and each cell has a name or reference based on its column and row.

• Start by selecting cell A1, typing your desired text, and tabbing over to create columns for different months.