Google Workspace 標準機能 Advent Calendar 2025

1 participant

14 followers

0 likes

Category：Service & Application

Creator：

@Masato_Takeda

Tags：

Google Workspace の便利な標準機能を投稿していくAdvent Calendar です。

Google ドキュメントの比較モードが超絶優秀！
Google スプレッドシートのハイライトでヒートマップが簡単に作れる！
Gmail の送信予約機能は便利！
Gemini 試してみた！
といったプログラミング要らずの標準機能から、
Google Apps Script やAppSheet の活用など、
Google Workspace や各種アプリケーションに関することならなんでもかまいません。
ぜひ気軽にご参加ください。

2025年のアドベントカレンダー
https://qiita.com/advent-calendar/2025/google
2024年のアドベントカレンダー
https://qiita.com/advent-calendar/2024/google
2023年のアドベントカレンダー
https://qiita.com/advent-calendar/2023/google
2022年のアドベントカレンダー
https://qiita.com/advent-calendar/2022/google

How to join the calendar

You can join the calendar by selecting an available date and registering the URL of the article you wish to link to. If a slot is available, you can go back to a past date to join!

Series 1

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
30	@Masato_Takeda Google スプレッドシートの日付入力が1日ズレる⁉︎タイムゾーンの設定を見直して！ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda たくさんの行の表の指定したセルに一瞬でジャンプ！セル番地直接指定やHYPERLINK 関数とMAXIFS 関数の応用で瞬時に最下部セルへ｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda TEXT 関数の応用で「〇〇年〇〇月分」の請求項目を「作成日」から自動で表示させる｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 予定の削除をしてほしいのに、不参加の予定が残り続ける…！不参加の返答と削除は違うんだってばよ｜Google カレンダー Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「分割表示」でChrome の2タブ分を1つのタブで表示｜Google Chrome Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 通貨形式にしたら日本円以外の記号が表示される！？ファイル＞設定＞言語と地域の設定による通貨の違いを確認してみよう｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda 日付の値を「曜日」の文字列にするためのいろいろなやり方｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 年末あるある「1/1」が今年の1月1日として入力されてしまう！あと数日後で来年だぞ｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「え？まだ12月32日ですよね？」って、締切を守れなかった時にすっとぼける日付表示の方法｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「先生、いい加減にしてください！12月34日なんてありません。もう1月3日です！」と、瞬時に正しい日付を示すDATE 関数の使い方｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドライブに保存するファイル名の長さに上限はあるのか？⇒9500文字っぽい？ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Windows でファイル名に使用できない文字を使用したファイルをダウンロードするとどうなる？｜Google ドライブ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドキュメントで総ページ数を表示したページ番号をフッターに表示する｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda 文字だけのGoogle ドキュメントをWord でダウンロードしたらファイルサイズがめちゃくちゃ重くなる！？フォントの種類の変更に注意 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドライブにWord Excel PowerPoint のファイルをアップロードしたら自動的にGoogle の形式に変更される？ドライブの設定を確認してみよう｜Google ドライブ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（年）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（月）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（日_最小値）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 複数のドキュメントタブのあるGoogle ドキュメントですべてのタブのダウンロードができるようになった｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google スプレッドシートにExcelのファイルとCSVのファイルをインポートするときの挙動の違い｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda Google スプレッドシートのグラフで駅伝の区間別順位推移っぽいものを作る｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda YEN 関数／DOLLAR 関数で数値を現地の通貨っぽい文字列として表示｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 年齢がばらついた会員データのサンプルを作成する方法／RANDBETWEEN TRUNC ROUNDDOWN INTなど｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda ピボットテーブルで会員情報の年齢から年代を丸めるグループ機能｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Googleドキュメントのチェックリストの形式が増えた！チェック付けても取り消し線が適用されない｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26	27

@Masato_Takeda
Google スプレッドシートの日付入力が1日ズレる⁉︎タイムゾーンの設定を見直して！
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
たくさんの行の表の指定したセルに一瞬でジャンプ！セル番地直接指定やHYPERLINK 関数とMAXIFS 関数の応用で瞬時に最下部セルへ｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
TEXT 関数の応用で「〇〇年〇〇月分」の請求項目を「作成日」から自動で表示させる｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
予定の削除をしてほしいのに、不参加の予定が残り続ける…！不参加の返答と削除は違うんだってばよ｜Google カレンダー
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「分割表示」でChrome の2タブ分を1つのタブで表示｜Google Chrome
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
通貨形式にしたら日本円以外の記号が表示される！？ファイル＞設定＞言語と地域の設定による通貨の違いを確認してみよう｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
日付の値を「曜日」の文字列にするためのいろいろなやり方｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
年末あるある「1/1」が今年の1月1日として入力されてしまう！あと数日後で来年だぞ｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「え？まだ12月32日ですよね？」って、締切を守れなかった時にすっとぼける日付表示の方法｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「先生、いい加減にしてください！12月34日なんてありません。もう1月3日です！」と、瞬時に正しい日付を示すDATE 関数の使い方｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドライブに保存するファイル名の長さに上限はあるのか？⇒9500文字っぽい？
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Windows でファイル名に使用できない文字を使用したファイルをダウンロードするとどうなる？｜Google ドライブ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドキュメントで総ページ数を表示したページ番号をフッターに表示する｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
文字だけのGoogle ドキュメントをWord でダウンロードしたらファイルサイズがめちゃくちゃ重くなる！？フォントの種類の変更に注意
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドライブにWord Excel PowerPoint のファイルをアップロードしたら自動的にGoogle の形式に変更される？ドライブの設定を確認してみよう｜Google ドライブ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（年）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（月）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（日_最小値）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
複数のドキュメントタブのあるGoogle ドキュメントですべてのタブのダウンロードができるようになった｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google スプレッドシートにExcelのファイルとCSVのファイルをインポートするときの挙動の違い｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google スプレッドシートのグラフで駅伝の区間別順位推移っぽいものを作る｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
YEN 関数／DOLLAR 関数で数値を現地の通貨っぽい文字列として表示｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
年齢がばらついた会員データのサンプルを作成する方法／RANDBETWEEN TRUNC ROUNDDOWN INTなど｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
ピボットテーブルで会員情報の年齢から年代を丸めるグループ機能｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Googleドキュメントのチェックリストの形式が増えた！チェック付けても取り消し線が適用されない｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
30	@Masato_Takeda Google スプレッドシートの日付入力が1日ズレる⁉︎タイムゾーンの設定を見直して！ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda たくさんの行の表の指定したセルに一瞬でジャンプ！セル番地直接指定やHYPERLINK 関数とMAXIFS 関数の応用で瞬時に最下部セルへ｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda TEXT 関数の応用で「〇〇年〇〇月分」の請求項目を「作成日」から自動で表示させる｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 予定の削除をしてほしいのに、不参加の予定が残り続ける…！不参加の返答と削除は違うんだってばよ｜Google カレンダー Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「分割表示」でChrome の2タブ分を1つのタブで表示｜Google Chrome Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 通貨形式にしたら日本円以外の記号が表示される！？ファイル＞設定＞言語と地域の設定による通貨の違いを確認してみよう｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda 日付の値を「曜日」の文字列にするためのいろいろなやり方｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 年末あるある「1/1」が今年の1月1日として入力されてしまう！あと数日後で来年だぞ｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「え？まだ12月32日ですよね？」って、締切を守れなかった時にすっとぼける日付表示の方法｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 「先生、いい加減にしてください！12月34日なんてありません。もう1月3日です！」と、瞬時に正しい日付を示すDATE 関数の使い方｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドライブに保存するファイル名の長さに上限はあるのか？⇒9500文字っぽい？ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Windows でファイル名に使用できない文字を使用したファイルをダウンロードするとどうなる？｜Google ドライブ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドキュメントで総ページ数を表示したページ番号をフッターに表示する｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda 文字だけのGoogle ドキュメントをWord でダウンロードしたらファイルサイズがめちゃくちゃ重くなる！？フォントの種類の変更に注意 Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google ドライブにWord Excel PowerPoint のファイルをアップロードしたら自動的にGoogle の形式に変更される？ドライブの設定を確認してみよう｜Google ドライブ Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（年）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（月）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（日_最小値）｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 複数のドキュメントタブのあるGoogle ドキュメントですべてのタブのダウンロードができるようになった｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Google スプレッドシートにExcelのファイルとCSVのファイルをインポートするときの挙動の違い｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda Google スプレッドシートのグラフで駅伝の区間別順位推移っぽいものを作る｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda YEN 関数／DOLLAR 関数で数値を現地の通貨っぽい文字列として表示｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda 年齢がばらついた会員データのサンプルを作成する方法／RANDBETWEEN TRUNC ROUNDDOWN INTなど｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda ピボットテーブルで会員情報の年齢から年代を丸めるグループ機能｜Google スプレッドシート Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	@Masato_Takeda Googleドキュメントのチェックリストの形式が増えた！チェック付けても取り消し線が適用されない｜Google ドキュメント Overwrite Title URL You can post either your article on Qiita or your blog post. About reserved posting If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day. About posting period Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.) When you participate, we will assume that you have agreed to the terms of use	26	27

@Masato_Takeda
Google スプレッドシートの日付入力が1日ズレる⁉︎タイムゾーンの設定を見直して！
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
たくさんの行の表の指定したセルに一瞬でジャンプ！セル番地直接指定やHYPERLINK 関数とMAXIFS 関数の応用で瞬時に最下部セルへ｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
TEXT 関数の応用で「〇〇年〇〇月分」の請求項目を「作成日」から自動で表示させる｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
予定の削除をしてほしいのに、不参加の予定が残り続ける…！不参加の返答と削除は違うんだってばよ｜Google カレンダー
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「分割表示」でChrome の2タブ分を1つのタブで表示｜Google Chrome
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
通貨形式にしたら日本円以外の記号が表示される！？ファイル＞設定＞言語と地域の設定による通貨の違いを確認してみよう｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
日付の値を「曜日」の文字列にするためのいろいろなやり方｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
年末あるある「1/1」が今年の1月1日として入力されてしまう！あと数日後で来年だぞ｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「え？まだ12月32日ですよね？」って、締切を守れなかった時にすっとぼける日付表示の方法｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
「先生、いい加減にしてください！12月34日なんてありません。もう1月3日です！」と、瞬時に正しい日付を示すDATE 関数の使い方｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドライブに保存するファイル名の長さに上限はあるのか？⇒9500文字っぽい？
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Windows でファイル名に使用できない文字を使用したファイルをダウンロードするとどうなる？｜Google ドライブ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドキュメントで総ページ数を表示したページ番号をフッターに表示する｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
文字だけのGoogle ドキュメントをWord でダウンロードしたらファイルサイズがめちゃくちゃ重くなる！？フォントの種類の変更に注意
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google ドライブにWord Excel PowerPoint のファイルをアップロードしたら自動的にGoogle の形式に変更される？ドライブの設定を確認してみよう｜Google ドライブ
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（年）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（月）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
DATE関数で年月日を作ってみよう！日付や引数の上限下限をまとめてみた！（日_最小値）｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
複数のドキュメントタブのあるGoogle ドキュメントですべてのタブのダウンロードができるようになった｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google スプレッドシートにExcelのファイルとCSVのファイルをインポートするときの挙動の違い｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Google スプレッドシートのグラフで駅伝の区間別順位推移っぽいものを作る｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
YEN 関数／DOLLAR 関数で数値を現地の通貨っぽい文字列として表示｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
年齢がばらついた会員データのサンプルを作成する方法／RANDBETWEEN TRUNC ROUNDDOWN INTなど｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
ピボットテーブルで会員情報の年齢から年代を丸めるグループ機能｜Google スプレッドシート
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use
@Masato_Takeda
Googleドキュメントのチェックリストの形式が増えた！チェック付けても取り消し線が適用されない｜Google ドキュメント
Overwrite
Title
URL
You can post either your article on Qiita or your blog post.
About reserved posting
If you register a secret article by the day before the same day, it will be automatically published around 7:00 on the same day.
About posting period
Only articles submitted after October 31, 2025 can be registered. (Secret articles can be registered anytime articles are posted.)
When you participate, we will assume that you have agreed to the terms of use

You can increase the number of series when Calendar 1 is filled with more than 10 articles.

Google Workspace 標準機能 Advent Calendar 2025

edit_calendarHow to join the calendar

Series 1

How to join the calendar