Locate and select cells by type: values, formulas, notes, blanks, visible cells, precedents, fill colors, dependents, validations, formatting, and differences.
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2025๋…„ 6์›” 28์ผ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
2์ฒœ+
๊ฐœ์š”
๐Ÿš€ Find, select, and highlight cells in spreadsheets with Select Special!
Select Special is a tool that helps you quickly find and select specific types of cells for data analysis, auditing, and cleanup.

๐Ÿ”Ž Key Features:
โœ… Find manually entered values โ€“ Select cells that contain typed data (numbers, text, dates, errors, etc.)
โœ… Highlight formulas & results โ€“ Select cells with formulas whose results match specified criteria (numbers, text, dates, etc.).
โœ… Identify row & column differences โ€“ Spot discrepancies in values and formulas across rows and columns for better data accuracy.
โœ… Trace precedents & dependents โ€“ See which cells affect or depend on a formula.
โœ… Find Colors โ€“ Identifies and highlights cells filled with color.
โœ… Find blank cells โ€“ Locate empty cells for cleaning or adding missing data.
โœ… Select visible cells only โ€“ Avoid hidden rows and columns when analyzing data.
โœ… Locate cells with data validation โ€“ Identify cells with specific validation rules.
โœ… Find cells with notes โ€“ Highlight cells that contain notes for context or collaboration.
โœ… Detect conditional formatting rules โ€“ Easily locate cells with conditional formatting applied.
โœ… Select entire data regions โ€“ Automatically detect and highlight contiguous data ranges.
โœ… Jump to the last data cell โ€“ Quickly navigate to the last cell in a dataset.

๐Ÿ” Works seamlessly in spreadsheet applications! Perfect for data analysts, accountants, and anyone working with large datasets.
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ๋ฌด๋ฃŒ
๊ฐœ๋ฐœ์ž
๋น„์‚ฌ์—…์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
Select Special์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
Select Special์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด Select Special์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์„ค์น˜ ์‹œ ์‚ฌ์šฉํ•œ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ์กฐํšŒ ๋ฐ ๊ด€๋ฆฌ
๋ชจ๋“  Google Sheets ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ™•์ธ
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
๋Œ“๊ธ€ ์—†์Œ
๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
Google ์•ฑ
๊ธฐ๋ณธ ๋ฉ”๋‰ด