Вопросы и ответы
Найдите ответы на популярные вопросы об Excel и Google Таблицах
How do I calculate a percentage in Excel?
Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.
How do I round numbers in Excel?
Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.
How do I calculate an average in Excel?
The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.
How do I raise a number to a power in Excel?
Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).
How do I get the absolute value in Excel?
The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.
How do I combine text from multiple cells in Excel?
Use the & operator or the CONCATENATE function. For example, =A1&" "&B1 joins cell contents with a space between them.
How do I strikethrough text in Excel?
Select the cell or text, then press Ctrl+5. Or go to Format Cells → Font tab → check 'Strikethrough'.
How do I count blank cells in Excel?
The COUNTBLANK function counts empty cells in a range. For example, =COUNTBLANK(A1:A100) shows how many cells are unfilled.
How do I set a print area in Excel?
Select the range you want, then go to Page Layout → Print Area → Set Print Area. Now only that selection will print.
How do I merge multiple Excel sheets into one?
Copy data from each sheet and paste onto a summary sheet. For automation, use Power Query: Data → Get Data → From Workbook.
How do I change text direction in an Excel cell?
Select the cell, on the Home tab click the 'Orientation' button (ab with an angled arrow) and choose your angle or vertical text.
How do I remove page numbers in Excel when printing?
Go to Page Layout → Page Setup → Header/Footer tab → select '(none)' for both header and footer.
How do I convert rows to columns in Excel (transpose)?
Copy the data, right-click → Paste Special → check 'Transpose'. Or use the TRANSPOSE function for a dynamic link.
How do I find and replace text in an Excel column?
Select the column, press Ctrl+H, enter the text to find and the replacement, then click 'Replace All'. The search stays within your selection.
How do I enter a fraction in an Excel cell?
Type 0, a space, then the fraction: '0 1/2' displays as ½. Or use the Fraction cell format for automatic conversion.
Не нашли ответ?
Опишите задачу простым языком — ИИ сгенерирует рабочую формулу Excel или Google Таблиц за секунды.
Попробовать генератор