AutoSave
кабинка-2bedd90a5bce46a033744265
Home

Clipboard

Paste
Font

Copy, cut, and paste visible cells from the current selection and active cell.

Clipboard
Главная

Шрифт

Абзац

Font, size, colour and borders apply to the current visible selection.

Шрифт
Главная

Выравнивание

Alignment applies to the current visible selection. Extended print layout and automatic row/column resizing remain separate tasks.

Выравнивание
Главная

Перенос и объединение

Wrap

Wrap, shrink to fit and merge apply to the current visible selection; extended print layout remains a separate task.

Перенос и объединение
Home

Number

Number

Basic number, percentage, currency, date, time, and text formats apply to the current visible selection.

Number
Главная

Стили

Conditional formatting applies visible styles to the selected numeric cells.

Стили
Главная

Ячейки

Ячейки

Insert, delete, hide, unhide and autofit work on the visible rows and columns of the current workbook.

Ячейки
Главная

Редактирование

Change Case: select a visible text cell.

Editing

Editing works on the visible cell, the formula bar, clear, cut, copy, paste and filling the selected range.

Редактирование
Paste
Clipboard
Font
Alignment
Paragraph
Cells
Number
Styles
Cells

Change Case: select a visible text cell.

Editing
A1

Choose data source

Choose a data source to connect through Power Query.

11 data sources

Рабочая область листа

Сетка, выделение и ввод работают в видимой области текущего листа.

kind=default-ltr-session-placeholder; workbook=ltr; active=ltr; writing=horizontal-tbНаправление листа применяется к текущему виду.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1Quarterly revenue by region, 2026
2Run the macro CloseQuarter to fill Total, vs plan and Status for every region. Nothing else changes.
3
4RegionQ1Q2Q3Q4TotalPlanvs planStatus
5North4133984424671,700,000
6South2883022963311,250,000
7East5124995305612,050,000
8West3763623904021,500,000
9Central198210206232900
10Nordics157150171188640
11Iberia2432522392621,020,000
12Benelux135141153161560
13
14Regions on plan
15
16Macro: Module1.CloseQuarter - see the VBA source in the Developer tab or ask the agent to explain it.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Canvas grid keeps keyboard focus on the visible cell selection. Arrow keys move the active cell inside the visible window. Alt+Up/Down and bottom-bar buttons move through visible read-only surface objects. Escape returns from object selection to cells.

Sheets 1 лист | только активная вкладка
Sheet1 -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified updated_truthfully
Sheet1 -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified values_only_same_workbook_sheet no no no no no no live_verified unreferenced_bounded_sheet_only live_verified last_unreferenced_bounded_sheet_current_session save_reopen_after_restore_live blocked_truthful_boundary no live_verified same_workbook_sheet_order_only true no true live_verified same_workbook_visible_hidden_very_hidden live_verified blocked_truthful_boundary live_verified same_workbook_worksheet_sheetPr_tabColor_rgb live_verified same_workbook_worksheet_sheetPr_codeName live_verified same_workbook_unpassworded_sheetProtection_metadata no live_verified active_worksheet_cells_only_preserve_sheet_metadata no

На текущем truthful path доступен только активный лист. Переключение листов и вставка листа здесь не доступны.

ReadyInsertingDeletingFittingOpeningSortingFiltering Cell mode
100 %