目次
はじめに ................................................................................................................. 1
1 章-1
1 章-2
1 章-32 章-1

エクセルの起動 ····················································································· 2
エクセルの画面の名称 ············································································ 3
ブックの画面の名称 ················································································ 4
データの入力をしよう··············································································· 5①セルの選択 ························································································ 6②名前ボックスとセル番地 ··········································································· 6③全角文字の入力 ················································································· 7④数式バー ·························································································· 7⑤半角文字の入力 ··············································································· 10⑥住所の簡単な入力方法 ······································································· 13⑦データの削除 ···················································································· 15⑧連続したセルの複数選択 ······································································ 17⑨データの一括削除 ·············································································· 18⑩データの上書き ·················································································· 19⑪データの部分修正 ·············································································· 20

2 章-2
3 章-1
3 章-2

名前を付けて保存 ······································································· 22
保存したファイルを開く ···································································· 28
名簿を作ろう ·············································································· 32①全セル選択 ····················································································· 32②フォントサイズの設定 ············································································ 33③選択の解除 ····················································································· 34④行の選択 ························································································ 35⑤列幅の変更 ····················································································· 36⑥複数の列幅の変更 ············································································· 37⑦列幅の自動調整 ··············································································· 38⑧行の高さの変更 ················································································· 39⑨複数の行の高さの変更········································································· 40⑩文字の配置 ····················································································· 42⑪フォントの設定 ··················································································· 44⑫セルの塗りつぶし ················································································ 46⑬フォントの色の設定 ············································································· 47⑭太字の設定 ····················································································· 48⑮斜体の設定 ····················································································· 49⑯下線の設定 ····················································································· 50⑰罫線の設定 ····················································································· 50

3 章-3
上書き保存 ······················································································· 53
エクセルを閉じずに操作する方法 ················································································· 55
ファイル名を間違えてしまった時は················································································· 56

4 章-14 章-2

オートフィルに挑戦しよう ········································································· 57
献立表を作ろう ·················································································· 62①セルの結合 ······················································································ 62②結合したセルのオートフィル ····································································· 63③縦書き ··························································································· 65④セル内の改行 ··················································································· 66⑤文字列のオートフィル ··········································································· 69⑥データのコピーと貼り付け ········································································ 70⑦データの切り取りと貼り付け ····································································· 73⑧広範囲のセルの選択 ··········································································· 75⑨罫線の設定〈色〉 ··············································································· 76⑩罫線の設定〈内側〉 ············································································ 78⑪罫線の設定〈外枠〉 ············································································ 78⑫部分的な罫線の設定 ·········································································· 80⑬ワードアートの挿入 ·············································································· 85⑭ワードアートの選択と移動 ······································································ 87⑮ワードアートの塗りつぶし ········································································ 88⑯ワードアートの輪郭 ·············································································· 89⑰ワードアートのサイズ変更 ······································································· 90⑱画像の挿入 ····················································································· 92⑲画像のサイズ変更 ·············································································· 95⑳画像の移動 ····················································································· 96

やってみよう
やってみようセルにパターンを設定する ······································································· 97
オートフィルオプション ············································································· 99

5 章-1

家計簿を作ろう ················································································ 101①データ入力 ···················································································· 101②日付の入力 ··················································································· 102③数式 ··························································································· 105④たし算·························································································· 106⑤ひき算 ························································································· 109⑥家計簿の数式の入力 ········································································ 112⑦数式のオートフィル ············································································ 114⑧セル参照 ······················································································ 117

5 章-2

関数に挑戦しよう ·············································································· 119①関数 ··························································································· 119②ＳＵＭ関数 ·················································································· 120③数式の修正 ··················································································· 123④関数のオートフィル ············································································ 126⑤桁区切りスタイル ·············································································· 128⑥通貨表示形式················································································ 129⑦シート ·························································································· 132⑧効率的な入力方法 ·········································································· 134

5 章-1 家計簿を作ろう

Ｇ5章 1

家計簿を作ろう
今度は家計簿作りに挑戦しましょう！

➊データ入力「空白のブック」を開きましょう。

1

以下のデータを入力しましょう。その後「家計簿」とUSB メモリに名前を付けて保存しましょう。
◢A

BC

1

家計簿

2

繰越金

3145

DEF

G

11月
今月残金

2残金合計

20000

45

番号

日付

6

17283941051161271381491510費目

詳細

収入支出残高ドラッグ

16

こんな方法も「1、2」を選択しオートフィルすると連番になります。
「1」だけ入力し、オートフィルした後、オートフィルオプションで「連続データ」にしても連番にできます。
101

5 章-1 家計簿を作ろう❷日付の入力1

入力モードを半角英数「A」に変更します。

◢A

B

C

1

家計簿

2

繰越金3D

E

FG

支出

残高

1月
今月残金

145

残金合計

20000

45番号

日付

6

17283

9410

5116

127費目

詳細収入クリックあA

2

Ｂ６にテンキーを使用して「1/10」と入力し、エンターキーを押します。
◢A

B

3C
145

DE

FG

詳細収入

支出

残高

20000

45番号

日付

6

17283

9410

5

116

12

713

814

91510費目

1/10

エンターキー

16
102

1/10

5 章-1 家計簿を作ろう

3「1 月 10 日」と表示されました。

◢A

B

3

C145

DE

F

G

詳細収入支出

残高

20000

4
5

番号

日付

617283941051161271381491510費目

1 月 10 日

1 月 10 日

16日付の表示形式
エクセルでは「1/10」と入力すると「1 月 10 日」と表示されるようになっています。
（「1-10」と入力しても「1 月 10 日」と表示されます）
C2▼… ✕ ✓◢

A

B

2020/1/10C

DE

F

G

12

１月 10 日34

数式バーを見ると「2020/1/10」と表示されています。
（西暦を特に入力しないとその年の西暦になります。
）
これはエクセルの機能で「2020/1/10」を「1 月 10 日」という表示に見せています。
値は変わらず見た目だけを変更する機能を「表示形式」と言います。
では、逆に「1/10」とさせたい時はどうすればいいのか？
それはエクセル基礎で説明します。
103

5 章-1 家計簿を作ろう

4

同様の手順でＢ７：Ｂ１１に以下の日付を入力しましょう。
◢A

B

3C145

D

E

F

G

1/1220000

4
5番号

日付

費目

61

1 月 10 日

72

1 月 12 日83

1 月 15 日

94

1 月 18 日

105

1 月 20 日

116

1 月 22 日

127138

14

915

10

詳細

収入

支出

残高

1 月 12 日
入力の際は「1/12」と入力して下さい。

165以下のデータを入力しましょう。

◢A

B

C

1

家計簿

2

繰越金

3145

D

EF

G

支出

残高

1月
今月残金残金合計

20000

45番号

日付

費目

詳細収入

61

1 月 10 日バイト代

721 月 12 日

貯蓄

831 月 15 日

食費

お菓子

941 月 18 日

バザー服など105

1 月 20 日

交際費

ランチ13201161 月 22 日

服飾費

シャツ

1650

127138149151020000
10000
385
3000

16104

5 章-1 家計簿を作ろう❸数式
今度はいよいよ数式の登場です

数式のルール●「＝（イコール）」を数式の前に入力する。
●指定の記号を使用する。
●半角英数で入力する。
〈数式でよく使う記号〉
名前記号

たす＋

ひく－

かける

＊

わる/

〈数式の優先順位〉
順位

計算

1( )カッコ内の計算

2

かけ算・わり算

3

たし算・ひき算(優先順位が同じものは、左から順番に計算されます。)
105

テンキーの位置