AutoSave
кабинка-b4d0bec8a56a6ecd2539846b
Home

Clipboard

Paste
Font

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

Главная

Шрифт

Абзац

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.

Главная

Стили

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
1Northwind Tools — cash flow 2026 and the 2027 forecast
2Actuals come from the bank export (query MonthlyCashflow, Data → Queries). Fill the three assumptions in I5:I7 and the 2027 forecast recalculates. The macro FlagCashGaps marks the months where cash runs out.
3
4MonthInflowsOutflowsNetCumulativeStatusForecast assumptions
5Jan 2026215196Revenue growth
6Feb 2026139209Cost inflation
7Mar 2026226202Opening cash 2027
8Apr 2026232205
9May 2026242212
10Jun 2026239214Summary — written by the macro FlagCashGaps
11Jul 2026219210
12Aug 2026150207
13Sep 2026245215
14Oct 2026257219
15Nov 2026264225
16Dec 2026281236
17Total 2026
18
19Forecast 2027 — from the actuals and the assumptions above
20MonthInflowsOutflowsNetCumulativeStatus
21Jan 2027
22Feb 2027
23Mar 2027
24Apr 2027
25May 2027
26Jun 2027
27Jul 2027
28Aug 2027
29Sep 2027
30Oct 2027
31Nov 2027
32Dec 2027
33Total 2027
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.