Deprecated: Return type of WP_Theme::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 554
Deprecated: Return type of WP_Theme::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 595
Deprecated: Return type of WP_Theme::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 535
Deprecated: Return type of WP_Theme::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 544
Deprecated: Return type of WP_REST_Request::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 952
Deprecated: Return type of WP_REST_Request::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 972
Deprecated: Return type of WP_REST_Request::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 984
Deprecated: Return type of WP_REST_Request::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 995
Deprecated: Return type of WP_Block_List::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 151
Deprecated: Return type of WP_Block_List::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 175
Deprecated: Return type of WP_Block_List::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 164
Deprecated: Return type of WP_Block_List::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 186
Deprecated: Return type of WP_Block_List::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 138
Deprecated: Return type of WP_Block_List::offsetExists($index) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 75
Deprecated: Return type of WP_Block_List::offsetGet($index) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 89
Deprecated: Return type of WP_Block_List::offsetSet($index, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 110
Deprecated: Return type of WP_Block_List::offsetUnset($index) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 127
Deprecated: Return type of WP_Block_List::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 199
Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp.php on line 173
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Deprecated: ltrim(): Passing null to parameter #1 ($string) of type string is deprecated in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/wp-db.php on line 3031
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
{"id":237,"date":"2016-08-25T20:19:47","date_gmt":"2016-08-25T18:19:47","guid":{"rendered":"http:\/\/excelshortcuts.info\/?p=237"},"modified":"2021-02-20T10:47:54","modified_gmt":"2021-02-20T08:47:54","slug":"excel-shortcut-lock-a-cell-reference","status":"publish","type":"post","link":"https:\/\/excelshortcuts.info\/excel-shortcut-lock-a-cell-reference\/","title":{"rendered":"Excel shortcut: Lock a cell reference"},"content":{"rendered":"\nIf you want to lock or unlock a cell reference in Excel, ie. toggle between relative and absolute references, you can type a Dollar sign in front of the reference you want to lock (A1 > $A$1, $A1 or A$1), or you can select the cell reference or range and use this shortcut:<\/p>\n\n\n\n