medusa0901的笔记

全部笔记

《微软Excel课程进阶篇》

来自在工作表中输入文字和数字 (0)

esc: delete cell contenttab: next cell in the rowenter: next cell in the columndecimal number: 1 2/4

来自创建新工作簿并同时浏览两个工作簿 (0)

switch between book1 and book2:window-->a list of workbooksto display multi workbooks:window-->arrangement

来自使用自动求和功能快速计算总值 (0)

autosum: calculates the sum for either the row or column

来自选择一个区域的单元格并理解智能标记 (0)

white cross: selectblack 4 headed cross: boundary, move black cross: auto fill in

来自在一个区域内输入信息并且复制 (0)

select 1 column/row first1. +bold=the selected column/row become bolded2. +shift=all adjacent columns/rows become selected3. +command=select only picked rows/columns

来自自动选择一个区域内的单元格区域进行计算 (0)

hold on the command key, drap two seperate columns, and click on the autosum button/enter key to get total

来自调整行高和列宽 (0)

select all the rows/columns you want to adjust and then resize one column/row and the rest will be auto adjusted.

来自创建自定义方程式 (0)

when calculating multiply or devide, first type in the result cell = and then use up arrow

来自使用自动填充功能输入文本以及数字序列 (0)

use auto fill, which is the black cross, for months/dates/same words...

来自使用自动填充功能调整方程式 (0)

auto fill also works for formulas

来自使用各种自动填充选项 (0)

change auto fill setting by chaning auto fill tag

来自为自动填充提速并且自定义填充序列 (0)

use autofill with control to enable copy not sequential results. edit-excel buttonoffice-excel optionion, self enter the setting for auto fill.

0在教
0课程
12笔记
0回答

昵称：medusa0901
等级：3
来自：
简介：

好友

关注（2）粉丝（1）