• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

Select Non-Adjacent Cells / Columns in Excel & Google Sheets

March 30, 2024 by admin Category: Top

You are viewing the article Select Non-Adjacent Cells / Columns in Excel & Google Sheets  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

How to Select Non Adjacent Cells in Excel
How to Select Non Adjacent Cells in Excel

Select Non-Adjacent Cells / Columns in Excel & Google Sheets

This tutorial demonstrates how to select non-adjacent cells or columns in Excel and Google Sheets.

Occasionally you may wish to format or delete the contents of cells or columns that are not next to each other. It is more efficient to select all these cells at once.

Table of Contents

  • Select Non-Adjacent Cells or Columns With the Keyboard
    • The Control Key
    • Shift F8 – Add to Selection
  • Select Non-Adjacent Cells or Columns Using Go To
  • Select Non-Adjacent Cells in Google Sheets

Select Non-Adjacent Cells or Columns With the Keyboard

The Control Key

  1. Select the first column or range of cells.
  2. Hold down the CTRL key on the keyboard and select the second range of cells.
  3. Keep holding down the CTRL key while selecting all the required ranges by dragging the mouse or using the arrows on the keyboard.
  1. You can then format or delete the contents of the cells, as needed.
  UNIQUE Formula for Non-Adjacent Columns

Shift F8 – Add to Selection

  1. By pressing SHIFT + F8 on the keyboard, you put Excel into Add to Selection mode.
  2. A message is shown on the status bar in the bottom left-hand corner of the Excel screen.
  1. With this mode you can select non-adjacent cells and columns by simply selecting them with the mouse.
READ More:   How to make super delicious, easy-to-make passion fruit cheesecake without oven

Select Non-Adjacent Cells or Columns Using Go To

  1. In the Ribbon, select Home > Find & Select > Go To.

Alternatively, press CTRL + G on the keyboard.

  1. In the Reference box, type in the range of cells you wish to select. Each range needs to have the cell addresses separated by a colon (:) and then each range of cells separated by a comma (,).
  1. Click OK to highlight the range of cells.

The ranges of cells do not need to match. You can select ten cells in one column and five cells in another if needed.

You can also select a row of cells and a column of cells together.

  How to Select Non-adjacent cells in Excel? (4 Easy Ways)

Select Non-Adjacent Cells in Google Sheets

Holding down the CTRL key on the keyboard and dragging over the required cells with the mouse is the only way that non-adjacent columns and cells can be selected in Google Sheets.

Thank you for reading this post Select Non-Adjacent Cells / Columns in Excel & Google Sheets at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

Related Search:

Related Posts

Bernd Leno: Hành Trình Sự Nghiệp Của Thủ Môn Tài Năng
Bernd Leno: Hành Trình Sự Nghiệp Của Thủ Môn Tài Năng
Dominic Calvert-Lewin: Ngôi sao sáng giá của bóng đá Anh
Dominic Calvert-Lewin: Ngôi sao sáng giá của bóng đá Anh
Nguyễn Thị Oanh – Ngôi sao sáng của điền kinh Việt Nam
Nguyễn Thị Oanh – Ngôi sao sáng của điền kinh Việt Nam

Category: Top

Previous Post: « 22 how many calories in a mandarin orange Quick Guide
Next Post: 20 how many carbs are in a cup of flour Advanced Guide »

Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge