home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PC World 2002 April
/
PCWorld_2002-04_cd.bin
/
Akce
/
demo
/
hlpsprd.z
/
ABSPREAD.CNT
(
.txt
)
next >
Wrap
Microsoft Windows Help File Content
|
2001-11-09
|
7KB
|
170 lines
:Base abspread.HLP
:Title Spreadsheet
:Index Function reference =Abfunc.hlp
:Index Integrating and linking =abintgrt.HLP
:Index Macros =macros.hlp
:Index WriteFX text effects =WriteFX.hlp
:Link Abfunc.hlp
:Link abintgrt.HLP
:Link macroc.hlp
:Link WriteFx.hlp
1 Getting started
2 What is Spreadsheet?=What_is_Spreadsheet
2 Starting Spreadsheet=Starting_Spreadsheet
2 Parts of the spreadsheet window
3 The spreadsheet window=The_spreadsheet_window
3 The toolbars and formatting bar=The_horizontal_toolbar_and_formatting_bar
3 The formula bar=The_formula_bar
3 Coolbars mode and large buttons=Coolbars_Mode_and_Large_Buttons
2 Moving around
3 Moving around a spreadsheet=Moving_around_a_spreadsheet
3 Going to a particular cell=Going_to_a_particular_cell
2 Cells, ranges, address - the basics
3 Spreadsheet definitions=Spreadsheet_definitions
3 Cells=Cells
3 Cell addresses=Cell_addresses
3 Cell ranges=Cell_ranges
1 Worksheets
2 Worksheets=Worksheets
2 Renaming a worksheet=Renaming_a_worksheet
2 Deleting a worksheet=Deleting_a_worksheet
2 Inserting a worksheet=Inserting_a_worksheet
2 Copying and moving worksheets=Copying_and_moving_worksheets
2 Linking worksheets=Linking_worksheets
1 Creating a spreadsheet
2 Creating a spreadsheet=Creating_a_spreadsheet
2 Opening an existing spreadsheet=Opening_an_existing_spreadsheet
2 Adding text, numbers and dates
3 Entering information=Entering_information
3 Entering text=Entering_text
3 Entering a long text item=Entering_a_long_text_item
3 Entering values=Entering_values
3 Entering currency values=Entering_currency_values
3 Entering a time=Entering_a_time
3 Entering dates=Entering_dates
3 Entering numbers you don't want to calculate=Entering_numbers_you_don_t_want_to_calculate
1 Formatting the cells
2 Formatting the spreadsheet=Formatting_the_spreadsheet
2 Cell font and style=Cell_font_and_style
2 Using the menus to select cell font and style=Using_the_menus_to_select_cell_font_and_style
2 Cell alignment=Cell_alignment
2 Formatting numbers, dates and currencies
3 Formatting a value=Formatting_a_value
3 Formatting a number=Formatting_a_number
3 Formatting a currency=Formatting_a_currency
3 Formatting a time=Formatting_a_time
3 Formatting a date=Formatting_a_date
3 Formatting a percentage=Formatting_a_percentage
3 Formatting a fraction=Formatting_a_fraction
3 Formatting a scientific number=Formatting_a_scientific_number
3 Formatting a boolean value=Formatting_a_boolean_value
3 Clearing a format=Clearing_a_format
2 Background colors and borders
3 Selecting the background color=Selecting_the_background_color
3 Adding borders=Adding_borders
2 Protecting the cells - locking and hiding
3 Protecting a spreadsheet=Protecting_a_spreadsheet
3 Locking and hiding cells=Locking_and_hiding_cells
2 Row and column sizing
3 Changing column width=Changing_column_width
3 Changing row height=Changing_row_height
1 Copying, moving and filling cells
2 Copying and moving information=Copying_and_moving_information
2 Copying and moving examples
3 Copying and moving from one cell to another cell=Copying_and_moving_from_one_cell_to_another_cell
3 Copying and moving from one range to another range=Copying_and_moving_from_one_range_to_another_range
3 Copying one cell to many other cells=Copying_one_cell_to_many_other_cells
3 Copying many cells to one=Copying_many_cells_to_one
3 Copying many cells to many other cells=Copying_many_cells_to_many_other_cells
2 Copying and moving with drag and drop
3 Drag and drop=Drag_and_Drop
3 Drag and move=Drag_and_Move
3 Drag and copy=Drag_and_Copy
2 Filling cells with data
3 Drag and fill=Drag_and_Fill
3 Filling cells automatically=Filling_cells_automatically
1 Deleting and inserting cells, rows and columns
2 Deleting and inserting cells, rows and columns=Deleting_and_inserting_cells_rows_and_columns
2 Drag and delete=Drag_and_Delete
2 Erasing the contents of a cell=Erasing_the_contents_of_a_cell
2 Inserting rows and columns=Inserting_rows_and_columns
2 Deleting cells, rows and columns=Deleting_cells_rows_and_columns
1 Comments
2 Comments=Comments
2 Editing comments=Editing_comments
2 Deleting comments=Deleting_comments
1 Merging and splitting cells
2 Merging and splitting cells=Merging_and_splitting_cells
1 Styles
2 Styles=Styles
1 Using formulas
2 Using formulas=Using_formulas
2 What is a formula?=What_is_a_formula
2 Arithmetic operators=Arithmetic_operators
2 How to enter a formula=How_to_enter_a_formula
2 Copying a formula=Copying_a_formula
2 Absolute addresses=Absolute_addresses
2 Clearing formulas=Clearing_formulas
2 Automatic totals=Autosum
2 Calculating current selection=Autocalc
2 Turning recalculation on and off=Auto_calculation
2 Link formulas
3 Linking=Linking
3 One way links=One_way_links
3 Two way or hot links=Two_way_or_hot_links
1 Naming cells and ranges
2 Naming cells=Naming_cells
2 Assigning names=Assigning_names
2 Changing or removing names=Changing_or_removing_names
2 Naming a range of cells=Naming_a_range_of_cells
1 Sorting and searching information
2 Sorting=Sorting
2 Searching=Searching
2 Finding next occurrence=Finding_next_occurrence
2 Finding a formula=Finding_a_formula
2 Replacing=Replacing
2 Replace next occurrence=Replace_next_occurrence
1 Transforming and transposing ranges
2 Transposing ranges=Transposing_ranges
2 Transforming ranges=Transforming_ranges
1 Pages, titles, headers and footers
2 Page set-up=Page_set_up
2 Headers and footers=Headers_and_footers
2 Adding a header and footer=Adding_a_header_and_footer
2 Freezing sections of a spreadsheet=Freezing_sections_of_a_spreadsheet
2 Splitting a spreadsheet=Splitting_a_spreadsheet
1 Printing
2 Printing=Printing
2 Print preview=Print_preview
2 Print set-up=Print_set_up
2 Printing the spreadsheet=Printing_the_spreadsheet
1 Spell checker and thesaurus
2 Spell-checker and thesaurus=Spell_checker_and_thesaurus
2 Autospell=Autospell
1 Spreadsheet options
2 Setting Spreadsheet options=Setting_Spreadsheet_options
2 General options=General_options
2 Custom lists=Custom_Lists
2 Choosing fonts=Choosing_fonts
2 Choosing background color=Choosing_background_color
1 Chart
2 Chart - introduction=Chart
2 Creating a chart=Creating_a_chart
2 Chart properties
3 Style=Chart_style
3 Gallery of chart styles=Gallery_of_chart_styles
3 More on Scatter charts=More_on_Scatter_charts
3 More on Hi-Low charts=More_on_Hi_Low_charts
3 Data range=Data_range
3 Vertical and horizontal series=Vertical_and_horizontal_series
2 Editing and printing charts
3 Editing a chart=Editing_a_chart
3 Attached charts=Attached_charts
3 Resizing and moving an embedded chart=Resizing_and_moving_an_embedded_chart
3 Deleting a chart from a spreadsheet=Deleting_a_chart_from_a_spreadsheet
3 Printing a chart=Printing_a_chart
:Include abfums.cnt
:Include abmcms.cnt
:Include abintgrt.CNT
:Include writefx.CNT