搜尋此網誌

2024年4月18日星期四

Revision of Excel Essential Course

Find within Sheet or within Workbook

若要搜尋工作表或整個活頁簿中的數據,請選取[工作表] 或[活頁簿]

support.microsoft.com


Position the cursor to fill handle of the cell with the formula, and then double-click it.

Note that double-clicking the fill handle copies the formula down as far as there is some data in the adjacent column(s).

Modified from ablebits.com


Change the Primary Vertical Axis display unit to "Millions"

Click anywhere in the chart

Chart Tools>Format>Vertical (Value) Axis

Format Selection>Axis Options>Display Units

support.microsoft.com


A chart legend appears by default when you first create a chart. For most charts, legends show the names and colors of each series of data.

mit.edu


To select multiple ranges, press the Control key while selecting a range or clicking on individual cells with the mouse.

brainly.in

Tab: move to the right

View>Show>Gridlines

沒有留言:

發佈留言