AutoSave
кабинка-b462133900037161a1134605
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Направление листа применяется к текущему виду.

count=17; objects=shape -> cataloged | shape -> cataloged | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupported | media -> unsupportedcatalog only; no object rendering claimed

Объекты книги17 visible object(s) on xl/worksheets/sheet1.xml; families=shape=2; object-like=15; renderStates=rendered=2; unsupported=15; source=open_workbook_subset surfaceObjects for the current canvas path; safe=inspect metadata or return to cell; unavailable=object editing, resizing, moving, and chart editing

Выбранный объектowner=cell; selected=none; activeCell=xl/worksheets/sheet1.xml!R0C0; source=xl/worksheets/sheet1.xml; safe=select visible object to inspect or continue cell work; unavailable=object editing, resizing, moving, and chart editing; return=cell ownership active; no selected-object state retained

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1
2
3Install VBA-WebAbout VBA-Web
4v4.1.6Guides
5
6Choose Excel Workbook/Access DatabaseDocs
7Issues
8
9
10
11
12TRUEInstall / Update VBA-Web
13TRUEVBA-Dictionary
14Windows and Mac alternative to Scripting.Dictionary
15FALSEAsyncWrapper
16(Windows- and Excel-only) Adds async functionality
17Authenticators
18FALSEHttp Basic
19FALSEOAuth1
20FALSEOAuth2
21FALSEDigest
22FALSEWindows
23FALSEGoogle
24FALSEFacebook
25FALSETwitterMIT License
26FALSETodoist
27FALSEEmpty© 2012-2018 VBA-tools, Tim Hall
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.