How Data is Organized in a Spreadsheet Program

How Data is Organized in a Spreadsheet Program – Applies to: Excel 2016 Excel 2013 Excel 2010 Excel 2007
Microsoft Office Excel has a number of functions that make it easy to manage and analyze data. To take advantage of these features, it is important to organize and format data in a spreadsheet according to the latest instructions.

  1. Instructions for organizing data
  2. Instructions for Formatting Data
  3. Instructions for organizing data

Colonial Similar Elements in the Same Column Arrange the data for all columns with similar elements in the same column.

Maintain a range of independent data On the other hand a blank column and a blank row between a range of related data and other data in the spreadsheet. Excel can more easily detect and select range when sorting, filtering, or inserting automatic subtotals.

Place Critical Data Up or Below Range Avoid placing important data to the left on the right side of the range, as it could hide the data when you filter the range.

Avoid Rows and Columns in a Range Avoid white columns and rows in a range of data. Make sure Excel can more easily detect and select related data ranges.

Show all rows and columns in a range Make sure columns are displayed before making changes in a range of data. When rows and columns are not displayed in a range, you can accidentally delete data. For more information, see Hide or show rows and columns.

Top of page

Instructions for Formatting Data

Use column labels to identify data Create column items in the first row of the range of data using a format other than the data. Excel, you can then use these words to create reports and to search and organize data. Use a font, alignment, format, model, uppercase style border for the column labels is different from the format that is assigned to rank data. Format cells as text before writing column labels. For more information, see ways to format a spreadsheet.

Commonly Used Borders to Distinguish Data When you want to separate the data labels, use cell borders – not blank rows or dashed lines – to insert lines beneath the labels. For more information, see Apply or remove cell borders in a worksheet.

Avoid initial and final spaces to avoid errors Avoid inserting spaces at the beginning and end of a cell to indent data. The spaces in advance that apply to a sort, search and format that applies to a cell. Instead of writing spaces to indent data, you can use the Increase indent command inside the cell. For more information, see Changing the Position of Data in a Cell.

Extending Data Formats and Formulas When you add new data sheets to the end of a range of data, Excel extends consistent formulas and formulas. Three of the five cells before using the same format for that format to expand. All previous formulas to be consistent extend a formula. For more information, see Automatically populate data in worksheet cells.

Use an Excel table format to work with related data You can convert a range of contiguous cells in the worksheet into an Excel table. The data that is defined in the table can be independently manipulated data outside the table and can use the specific characteristics of a table to sort, filter, total or calculate table data. You can also use the table feature to compare related datasets by organizing data into multiple tables in a single worksheet. For more information, see General information about Excel tables.

Top of page

How Data is Organized in a Spreadsheet Program

how is data organized in a spreadsheet application

NOTES:

Declining Automatic Translation Transfers: This article has been translated with a computer system without human intervention. Microsoft offers these automatic translations for speakers of other languages. Since this article has been translated with automatic translation, it is possible that it contains errors of vocabulary, syntax or grammar.

For your reference, you can find the English version of this article here. All members of the Microsoft community can improve this article through the Collaboration in Translation (CTF) framework. Simply move the pointer over any phrase in the article, and then click “IMPROVE TRANSLATION” on the CTF widget. Click here for more

How Data is Organized in a Spreadsheet Program

See More!

Tag :How Data is Organized in a Spreadsheet Program, Spreadsheet