⚡数式

How to 絶対参照と相対参照を切り替える in Google Sheets

絶対参照（$A$1）、複合参照（$A1、A$1）、相対参照（A1）のセル参照を順番に切り替えます。

F4

📋 Step-by-Step Guide

  1. 1.Open Google Sheets in your browser.
  2. 2.Select the cell(s) you want to work with.
  3. 3.Press F4 to 絶対参照と相対参照を切り替える.

🎯 Shortcut Keys by Platform

PlatformShortcut
💻 PC / Windows
F4
🍎 Mac
Fn + F4
💻 Chrome OS
F4

💡 Pro Tips

  • You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
  • If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.

❓Frequently Asked Questions

📚

Explore All Google Sheets Shortcuts

Discover all 111 keyboard shortcuts to speed up your workflow and boost your productivity.

View All Shortcuts ➜