HomeApplicationOffice informationMS Excel 2003 - Lesson 3: Manipulating data in spreadsheets

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets

1, Default Font Format for spreadsheets

The previous article TipsMake.com has guided you to some basic formatting for a small data area, but if you need to format a large area or the default format for a new Excel 2003 file, follow these instructions. .

a, Default Font Format

- Go to Format -> Style .

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets Picture 1

With the following formats:

- Style name : name the type of attribute you use.

- Style includes : list with the required format properties

- Modify . : edit the format properties

- Add : click Add to save the changes needed in a style.

- Delete : Delete an unnecessary style.

b, Black out the spreadsheet

- Black out the entire worksheet : Click on the empty square to intersect the line title and column header.

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets Picture 2

- Apply black lines or black out columns : click on the name of the row or column to be highlighted

2, Automatic numbering

Some ways to number automatically:

a, Option 1 (this way can be applied to non-consecutive numbers):

- Enter the first 2 numbers of the sequence

- Blacken the two cells entered

- Move the cursor to the lower right of the highlighted area (place the cursor like copying the formula: the mouse pointer is a black plus sign)

- Hold down the mouse and drag to the required number.

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets Picture 3

Note : You can drag the number sequence from top to bottom, from the bottom up, from the left and from the right. Also, in this way, you can number non-interconnected numbers (sequences with arithmetic progressions).

b, Method 2 :

- Enter the first number of the sequence

- Put the mouse pointer in the lower right corner of the cell just entered

- Hold down Ctrl + drag the number to enter

Because dates are a special form of numeric type, if you want to quickly fill in dates, you can also use the above methods.

3, Fill numeric values ​​on a region

Excel spreadsheets allow you to fill numeric values ​​into a predefined data area (with this feature you can also enter numbers automatically)

- Enter the value in the first box

- Apply black areas to fill (can be column or row or region)

- Go to Edit -> Fill -> Series .

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets Picture 4

- Series in :

  1. Rows: Enter the value in line
  2. Columns: Enter values ​​in columns

- Type :

  1. Linear: linear (vertical or horizontal)
  2. Growth: Enter the sequence of numbers exponentially
  3. Date: enter the date value
  4. AutoFill: Automatically enter the number or date according to Step value of 1

- Date unit : applies only to the date type value

  1. Day: sequentially increasing, decreasing by day
  2. Weekday: sequentially increase, decrease by working day of the week (except on Saturdays and Sundays)
  3. Month: sequential increase, decrease by month
  4. Year: sequential increase, decrease year by year

- Step value : type in the jump value (negative number: the jump is reduced, the number is positive: the step jumps

- Stop Value : the maximum value of the sequence

Also you can fill the values ​​faster without entering the Series dialog: Go to Edit -> Fill

MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets Picture 5

- Down : Fill down

- Right : Fill right

- Up : Fill up

- Left : Bright left

( Also )

5 ★ | 2 Vote
excel 2003

You should read it

May be interested

  • Set password protection file not open and save content editPhoto of Set password protection file not open and save content edit
    ms word: you want to protect your documents that no one can read; or just read without editing, quantrimang.com will guide you how to set a password to protect the file as follows:
  • Set password to protect text file content but still be readable (Office 2003)Photo of Set password to protect text file content but still be readable (Office 2003)
    ms word: you want to share the text file content for others to read, but you don't want the data in your file to be edited; quantrimang.com will show you how to do the following:
  • Change some options in MS WordPhoto of Change some options in MS Word
    ms office always set up some basic features for users, but also optionally (option) can change some suitable features set by users. quantrimang.com would like to introduce how to change some options as follows:
  • Welcoming the new year with sweet lettersPhoto of Welcoming the new year with sweet letters
    these days the atmosphere of christmas and new year is flooding the streets, and in your inbox, there must be many e-mails to congratulate with the image of snow, santa claus and busy music. you also want to do such a thing to give you b & egra
  • Use antivirus protection in Outlook Express 6Photo of Use antivirus protection in Outlook Express 6
    security zones allow you to choose which content to enable (such as activex control and script controls) that can be run inside html e-mail in outlook express. default outlook express 6 uses restricted zone instead of internet zone (extended area)
  • New points in Microsoft Office Word 2007Photo of New points in Microsoft Office Word 2007
    microsoft office word 2007 helps you organize your documents professionally by providing tools for creating and formatting documents in a new interface. the ability to review, comment (commenting) and make a rich comparison helps you

Office information