query-demo.xlsx - SumSheet

AutoSave

кабинка-93313e47f51aea2dab57c709

Delimiter Custom Encoding Interpretation Locale

Recents Recent files will appear after opening a workbook

Delimiter Custom Encoding Quotes Line endings

AutoSave

Home

Clipboard

Paste

Paste Options:

Paste

Paste Values

Other Paste Options

Font

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

Clipboard

Главная

Шрифт

Theme Fonts

Recent Fonts

      Marker Felt
    

Borders

Draw Borders

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Абзац

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

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

Number

Главная

Стили

Highlight Cells Rules▶

Top/Bottom Rules▶

Data Bars▶

Gradient Fill

Solid Fill

Color Scales▶

Icon Sets▶

Directions

Shapes

Indicators

Ratings

Clear Rules▶

Conditional formatting applies visible styles to the selected numeric cells.

Стили

Главная

Ячейки

Insert

Cells, shift right Cells, shift down Row Column

Insert blank visible cells and shift existing cells in the selected direction.

Delete

Cells, shift left Cells, shift up Entire row Entire column

Delete visible cells and shift remaining cells in the selected direction.

Cell Size

Visibility

Organize Sheets

Theme Colors

Standard Colors

Recent Colors

More Colors...

Protection

Ячейки

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 Options:

Paste

Paste Values

Other Paste Options

Paste

Clipboard

Theme Fonts

Recent Fonts

      Marker Felt
    

Borders

Draw Borders

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Font

Alignment

Paragraph

Cells

Number

Highlight Cells Rules▶

Top/Bottom Rules▶

Data Bars▶

Gradient Fill

Solid Fill

Color Scales▶

Icon Sets▶

Directions

Shapes

Indicators

Ratings

Clear Rules▶

Table Styles

Light

Medium

Dark

Styles

Delete

Cells, shift left Cells, shift up Entire row Entire column

Delete visible cells and shift remaining cells in the selected direction.

Cell Size

Visibility

Organize Sheets

Theme Colors

Standard Colors

Recent Colors

More Colors...

Protection

Insert

Cells, shift right Cells, shift down Row Column

Insert blank visible cells and shift existing cells in the selected direction.

Cells

Change Case: select a visible text cell.

Editing

✓

Questions

Form link

Picture from File…

Available windows

Stock 3D Models

Stock Images…

Recently Used Shapes

Lines

Rectangles

Basic Shapes

Block Arrows

Equation Shapes

Flowchart

Stars and Banners

Callouts

Insert Hyperlink

Text to Display: ScreenTip...:

Link to an existing file or web page.

Address:

Create a link to a cell in the current workbook.

Cell Reference:

Create a link that opens a new email message.

Email Address: Subject:

Link: select a visible cell.

Special Symbol: select a visible text cell.

Office

Width:

Height:

Gridlines View Print

Headings View Print

Recently used functions will appear here after you insert one.

Calculation Options

Workbook calculation Automatic Automatic Except Data Tables Manual Recalculate before saving

Iterative calculation Enable iterative calculation Maximum Iterations Maximum Change

Highlighted

Filter Values

Get Data

From Web

Fetch a bounded CSV or TSV table and load it into the active visible sheet range.

URL

0 rows 0 columns

Live for http(s) CSV/TSV up to the visible bounded output range. Database connectors and Power Query M are separate non-claims.

Get Data

From JSON Endpoint

Fetch a bounded JSON table endpoint, run a supported SELECT query, and load the result into the active visible sheet range.

URL Query

0 rows 0 columns

Live for http(s) JSON row endpoints and a bounded SELECT/WHERE/ORDER BY subset. ODBC, auth, joins, writes, and Power Query M are separate non-claims.

Get Data

From Online Services

Connect to a bounded public JSON or CSV online service, preview the rows, and load them into the active visible sheet range.

Service URL Query

0 rows 0 columns

Live for unauthenticated http(s) JSON rows and CSV/TSV feeds. OAuth, SharePoint/OneDrive, OData metadata, SaaS credentials, scheduled refresh, and broad Excel connector parity are non-claims.

Get Data

Launch Power Query Editor

Transform the current selected range and load the bounded result next to the source range.

Transform Script

0 rows 0 columns

Live for bounded selected-range transforms. Native M evaluation, query folding, refresh schedules, joins, and connector credentials are separate non-claims.

Forecast

Forecast Sheet

Preview a bounded linear forecast, then write the worksheet output and chart into the current workbook.

Forecast periods Chart type Confidence interval Confidence level

0 points 0 forecast periods n/a

Live for visible two-column numeric x/y selections. The current lane writes a bounded linear forecast and chart; ETS seasonality and arbitrary destination pickers remain non-claims.

Data Tools

Analyze Data

Summarizes the selected visible cells without sending data to an external service.

0 values none

Data Analysis

Analysis Tools

Bins Bin source Histogram order Cumulative percent Moving period Moving method EMA alpha % Smoothing alpha % Statistics alpha % t-Test tails Sampling interval Sampling method Sample size Random seed Random rows Generator seed Fourier points

disabled disabled disabled disabled disabled disabled sum disabled disabled disabled

Sort & Filter: select a visible table range, numeric row, or numeric column before using sort and filter actions.

Select a visible table range with headers to sort rows.

Select a visible table range with headers to filter rows.

Select one visible column with separated text to split into adjacent columns.

Select a visible range with at least two rows to remove duplicate rows.

Select two visible 2x2 numeric source ranges side by side.

Select two number columns to create a forecast table and chart.

Select a visible range with headers and numbers to add or update a total row.

Select grouped visible rows with numeric values to add subtotals.

Select a cell with a list rule, or select a one-column source list to create one.

Ruler Gridlines Formula Bar Headings

Zoom

Table Name

Select a cell inside an Excel table to use table commands.

Table Name

none

Table Styles

Light

Medium

Dark

Choose a visible table style for the selected range.

PivotTable Name:

Generate GetPivotData

PivotTable Options

PivotTable Name:

Display

Show expand/collapse buttons Print expand/collapse buttons Show contextual tooltips Display field captions and filter drop downs Classic PivotTable layout For error values show: For empty cells show: Show items with no data on rows Show items with no data on columns

Printing

Repeat row labels on each printed page Set print titles

Layout

Allow multiple filters per field Autofit column widths on update Preserve cell formatting on update Merge and center cells with labels Indent row labels in compact form:

Report filter

Down, Then Over Over, Then Down Report filter fields per column:

Sorting

Use Custom Lists when sorting

PivotTable Data

Save source data with file Enable show details Refresh data when opening the file

Retain items deleted from the data source

Automatic Max

Title Description

A title and description provide an alternative representation of the PivotTable for people with visual or cognitive impairments.

Active field:

Change PivotTable Data Source

Choose the data that you want to analyze.

Use a table or range in this workbook

Table/Range:

Use an external data source

Layout

PivotTable Style Options

PivotTable Styles

Chart name:

PivotTable Name:

Generate GetPivotData

PivotTable Options

PivotTable Name:

Display

Printing

Repeat row labels on each printed page Set print titles

Layout

Allow multiple filters per field Autofit column widths on update Preserve cell formatting on update Merge and center cells with labels Indent row labels in compact form:

Report filter

Down, Then Over Over, Then Down Report filter fields per column:

Sorting

Use Custom Lists when sorting

PivotTable Data

Save source data with file Enable show details Refresh data when opening the file

Retain items deleted from the data source

Automatic Max

Title Description

A title and description provide an alternative representation of the PivotTable for people with visual or cognitive impairments.

Active field:

Axes ▶

Axis Titles ▶

Chart Title ▶

Data Labels ▶

Data Table ▶

Error Bars ▶

Gridlines ▶

Legend ▶

Lines ▶

Trendline ▶

Up/Down Bars ▶

Change Colors

Colorful

Monochromatic

▾

Change Colors

Colorful

Monochromatic

▾

Change
Chart Type

Bring Forward ▾

Send Backward ▾

Align ▾

Group ▾

Change Graphic ▾

▾

Presets

Graphics Fill ▾

Theme Colors

Standard Colors

Recent Colors

More Fill Colors…

▾

Theme Colors

Standard Colors

Recent Colors

More Outline Colors…

Weight

▾

Shadow

Bring Forward ▾

Send Backward ▾

Align ▾

Group ▾

Rotate ▾

Height: Width:

Edit Shape ▾

▾

Shape Fill ▾

Theme Colors

Standard Colors

Recent Colors

More Fill Colors…

▾

Theme Colors

Standard Colors

Recent Colors

More Outline Colors…

Weight

Dashes

Arrows (connectors)

Begin

End

▾

Shadow

▾

Text Fill ▾

Theme Colors

Standard Colors

Recent Colors

More Text Colors…

▾

Theme Colors

Standard Colors

Recent Colors

More Outline Colors…

▾

Shadow

Bring Forward ▾

Send Backward ▾

Align ▾

Group ▾

Rotate ▾

Height: Width:

Особый колонтитул для первой страницы Different Odd & Even Pages Изменять масштаб вместе с документом Выровнять относительно полей страницы

▾

Sparkline Color ▾

Theme Colors

Standard Colors

Recent Colors

More Colors…

Marker Color ▾

Theme Colors

Standard Colors

Recent Colors

More Colors…

Open: choose a file from disk to replace the current workbook in the workspace. Save status: current local .xlsx subset is shell-wired for save_workbook_subset, but live save still depends on a host bridge that exposes that operation. Clipboard: copy, cut, and paste are available for the visible area of the opened editable workbook. XLSX open stays on the current truthful subset path. Canvas renders the viewport returned by open_workbook_subset, and the compatibility panel remains the existing degraded structure-only report. xlsx-subset /opt/sumview/cabins/queries/кабинка-93313e47f51aea2dab57c709.xlsx xlsx-subset false apply_cell_edits only bridge-missing waiting for file open_workbook_subset none none 1: Orders bridge-missing bridge-missing bridge-missing bridge-missing xlsx-zip-package xlsx-zip-package A1:I37 top=0, left=0, rows=96, cols=56 false

! Failure detected

Interface language

Page Setup

Orientation

Portrait Landscape

Scaling Adjust to % normal size Fit to page(s) wide by tall

First page number:

Top:

Header:

Left:

Right:

Bottom:

Footer:

Center on page:

Horizontally Vertically

Header

Footer:

Different odd and even pages Different first page Scale with document Align with page margins

Print area:

Print Titles

Rows to repeat at top:

Columns to repeat at left:

Print Options

Gridlines Black and white Draft quality Row and column headings

Comments:

Page Order

Down, then over Over, then down

Page setup is ready.

Header

To customize the header or footer, place the cursor in the section, and then choose the content you want to insert.

Left section:

Center section:

Right section:

Unsaved changes

This workbook has unsaved changes. What would you like to do?

Save changes before closing?

This workbook has unsaved edits.

Choose Save and Close, close without saving, or cancel and return to the workbook.

Save the workbook before closing, or use New/Open and choose how to handle unsaved changes.

Convert to Range

Do you want to convert the table to a normal range?

Choose data source

Choose a data source to connect through Power Query.

11 data sources

Advanced Filter

Action Filter the list, in-place Copy to another location

List range: Criteria range: Copy to:

Unique records only

Consolidate

Function: Reference:

All references:

Create links to source data

Use labels in Top row Left column

Find & Select

Find

Find what Replace with

Match case Match entire cell contents

Look in

Within

Enter a search term.

Compatibility Center

What this workbook's macros are, and what happens if you run one.

Reading the VBA project through the compute contract…

Project

Entrypoints

Run

0 / 1

What committing this run would change

Incomplete by declaration: structural changes are named but NOT located — an inserted or deleted band is reported as “cells were inserted on <sheet>” and never as the rows or columns that moved. And no answer here can promise the list is all of it: an undescribed structural write degrades it to “incomplete”. Read this list as at least this much, never as exactly this much.

Find & Select

Go To

Reference

Find & Select

Go To Special

Visible cells only

Constants

Numbers Text Logicals Errors

Formulas

Numbers Text Logicals Errors

Blanks

Comments and Notes

Objects

Last cell

Row differences

Column differences

Precedents

Dependents

Current array

Current spill range

Data Validation

Conditional Formatting

Find & Select

No cells were found that meet the specified criteria.

Data Tools

Remove Duplicates

Select the columns that contain duplicate values.

My data has headers

Data Tools

Data Validation

Settings Input Message Error Alert

Validation criteria

Allow Ignore blank Data In-cell dropdown Source Formula 2 Cell

Show input message when cell is selected

When cell is selected, show this input message:

Title Input message

Show error alert after invalid data is entered

When user enters invalid data, show this error alert:

Style Title Error message

Workbook Links

Links found in saved formulas. External files are not opened or refreshed.

0 links

Queries & Connections

Workbook Queries & Connections

0 connections 0 links 0 tables

Category Name Description Last Refreshed

Properties

Locations where connections are used in this workbook

Table

Resize Table

Select the new data range for your table.

Range

Table

Properties

Excel table properties

Table Name Range none

Table Style none

Source none

Selected column Total Row formula

Table Style Options

Header Row: off Total Row: off Banded Rows: off Filter Button: off

Table properties are ready.

There's a problem with this formula.

Check the sheet name and use a valid cell or range reference.

New Name

Edit Name

Name Scope Comment Refers to

Paste Name

Defined Names

Create Names from Selection

Top row Left column Bottom row Right column

Delete Table

Do you want to delete this table?

Format as Table

Where is the data for your table?

Range My table has headers

Format

Format Cells

Number

Sample Format not specified

Decimal places Symbol Use 1000 Separator ( )

General format cells have no specific number format.

Negative numbers

Number is used for general display of numbers. Currency and Accounting are also available for money values.

Negative numbers

Currency formats are used for general monetary values.

Accounting formats align currency symbols and decimal points in a column.

Type

Locale Calendar type

Date formats display date and time serial numbers as date values. Date formats that begin with an asterisk (*) respond to regional date and time settings specified for the operating system.

Type

Locale

Time formats display date and time serial numbers as time values.

Percentage formats multiply the cell value by 100 and display a percent sign.

Type

Scientific formats display numbers in exponential notation.

Text formatted cells are displayed exactly as typed and are treated as text.

Type

Locale

Special formats are useful for database and address list values.

Type

Enter a number format code, using one of the existing codes as a starting point.

Alignment

Horizontal Vertical

Indent Distributed

Orientation

Label

Degrees

Display

Wrap Text Shrink to fit Merge Cells

Border

Line style

Border line color

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Presets

Individual

Sample Sample

Apply saved thin border presets to the selected visible cells.

Fill

Fill Color

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Pattern Color

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Pattern

Sample

Protection Locked Hidden

Locking cells or hiding formulas has no effect until the sheet is protected (Review → Protect Sheet).

Font

Font family

Font Style

Font size

Underline Single Font Color

Only high-contrast colors

Theme Colors

Standard Colors

Recent Colors

Bold Italic

Effects Strikethrough Superscript Subscript

Sample

AaBbCcYyZz

Paste Special

Paste

All Formulas Values Formats Comments and Notes Validation Using Source theme No Borders Column widths Formulas and Number Formats Values and Number Formats Keep Text Only Picture Linked Picture All merging conditional formats

Operation

None Add Subtract Multiply Divide

Skip blanks Transpose

Source:

Paste: Paste Link:

As:

Unicode Text Text

Result

▥ → ▤

Inserts the Clipboard contents as Unicode Text.

Display as icon

surface-only

Text Import Wizard (Import) - Step 1 of 3

1Type 2Delimiters 3Format

The data has been interpreted as a delimited list of values.

If this is correct, choose Next; otherwise choose the data type.

Delimited characters such as commas or tabs separate each field Fixed width fields are aligned in columns with spaces

Start import at row: Destination: File origin:

Choose the delimiters your data contains.

Delimiters

Tab Semicolon Comma Space Other:

Treat consecutive delimiters as one Text qualifier:

Set field widths for fixed-width data.

Click the preview to add a column break. Double-click a break to remove it.

Choose the data format for the imported columns.

Column data format

General converts numeric values and dates where possible Text imports values as text Date Do not import column (skip)

Selected column: 1

Decimal separator: Thousands separator: Trailing minus for negative numbers

Preview of selected data:

Clipboard preview is not loaded yet.

closed

Series

Series in

Rows Columns Trend

Type

Linear Growth Date AutoFill

Date unit

Day Weekday Month Year

Step value Stop value

Select a single row or column range.

surface-only

Colors

Color Profile

Brightness 0 %

Red 0 Green 0 Blue 0 Hex Color

Hue 0 Saturation 0 % Brightness 0 %

Cyan 0 % Magenta 0 % Yellow 0 % Black 0 %

Zoom

Zoom to:

200% 150% 125% 100% 75% 50% 25% Fit selection Custom: %

Recent

Name Last opened by you

Recent files will appear after opening a workbook

Export status

Preview the workbook pages, then choose where to save the PDF.

Export status Available save choices are separated from disabled formats.

Create PDF

Preview the workbook pages, then choose where to save the PDF.

Export

WorksheetsFor selected sheets or the whole workbook, you can enter an optional page range beside each worksheet.

Include hidden sheets

PagesLeave blank for all pages. You can use ranges such as 1-3, 5.

Preview requiredNo file is written until you choose Create PDF.

Workbook кабинка-93313e47f51aea2dab57c709.xlsx

Workbook is open

Choose a workbook action.

File name: кабинка-93313e47f51aea2dab57c709.xlsx
active sheet: Orders
Sheets: 2
Viewport: 96 x 56, R1C1
Visible cells: 260
Formula cells: 0
Format: XLSX workbook
Save status: Save available
Calculation: Up to date

Page Setup

Orientation: Landscape
Margins: Normal
Size: Letter
Scale: 100%
Print options: Not set

Export status Available save choices are separated from disabled formats.

Create PDF

Preview the workbook pages, then choose where to save the PDF.

Export

WorksheetsFor selected sheets or the whole workbook, you can enter an optional page range beside each worksheet.

Include hidden sheets

PagesLeave blank for all pages. You can use ranges such as 1-3, 5.

Preview requiredNo file is written until you choose Create PDF.

Interface language

Surface language

Recent Files

Name Last opened by you

Recent files will appear after opening a workbook

Workbook Information кабинка-93313e47f51aea2dab57c709.xlsx

Review workbook properties and inspect the package for hidden or personal data.

Check for Issues

Find hidden data, choose supported categories, and save a sanitized copy without changing the source workbook.

Preview target-specific data-loss risks before saving a copy.

Repair, Recovery, and Versions

Preview a safe repair plan for a damaged workbook, review file conflicts, or restore and compare an earlier version.

Repair: Checked when a workbook is opened; changes require a preview and confirmation.
File conflict: Checking workbook ownership and revision…
Recovery identity: Actions are limited to this workbook session and identity.

Manage Workbook

Recover Unsaved Workbooks

Checking this workbook for recoverable local snapshots…

Cancel, stale plans, conflicts, and unsupported package content publish no partial workbook state.

Digital Signatures

Inspect signature origins, signed parts and relationships, digest integrity, algorithms, and certificate metadata. Certificate-chain trust is reported only when checked by a real trust provider.

Featured

Planners & tracking

Finance

My templates

Recent Files

Name Last opened by you

Recent files will appear after opening a workbook

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

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

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

Вид A нет отсутствует

Вид B нет отсутствует

Вид A не восстановлен Вид B не восстановлен Нет данных для восстановления Нет действий восстановления

Виды восстановлены

data.view-create-from-selection=disabled; data.view-refresh-active=disabled; data.view-clear-active=disabled; data.view-reapply-bounded=disabled; data.view-switch-bounded=A:disabled,B:disabled

Boundary: scalar edits save; view state is not broadly persisted. Reapply after reopen.

scalar_data_dirty=false; scalar_data_saved=false; manager_state_persistence=not_persisted; reapply_available=false

close_guard_visible=false; save_action_available=false; scalar_data_dirty=false; scalar_data_saved=false; manager_state_persistence=not_persisted; reapply_available=false

resume_prompt_visible=false; resume_action_enabled=false; review_surface_visible=false; selective_restore_supported=false; view_a_state=pending; view_b_state=pending; partial_resume_state_dirty=false; restart_resume_available=false; restore_remaining_action_enabled=false; cancel_partial_resume_enabled=false; restore_all_action_enabled=false; manager_state_restored=none

manager_state_persistence=not_persisted; reason=view_manager_state_not_saved; reapply_available=false; persisted_views=none

status_clear=true; normal_reapply_available=false; fresh_refresh_pending=false; recovery_pending=false; resolved_summary_available=false

normal_reapply_action=disabled; refresh_active_view_action=disabled; restore_all_views_action=disabled; source=contract_registry status=clear; reason=n/a; normal_reapply_action_reason=no_reapply_available; refresh_active_view_action_reason=no_active_refresh_needed; restore_all_views_action_reason=no_recovery_pending; source=contract_payload

Найдите заголовки Region и Amount на видимом листе, чтобы включить сохранённый вид.

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.

Comments

Search comments

Showing 0 of 0

No comments match this filter.

Comments and notes from this workbook.

Print preview

Sheets 2 листа | видимые вкладки

Orders -> xl/worksheets/sheet1.xml

ready n/a live_verified live_verified updated_truthfully

Orders -> 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

Нижний shell показывает видимые вкладки книги. Переключение листов live только при host bridge; вставка листа остаётся non-live.

Queries & Connections

No queries loaded to worksheets

ReadyInsertingDeletingFittingOpeningSortingFiltering Cell A1 A1 Save bridge-missing Clipboard bridge-missing Cell mode No objects selected Objects: 0/0

Cell: A1.

Average — Count 0 Numerical Count 0 Minimum — Maximum — Sum —

Status bar settings

100 %

Stock Images

Format Shape

Shape Styles

Fill

No fill Solid fill Gradient fill Picture or texture fill Pattern fill

Direction

Color 1

#5B9BD5

Color 2

#FFFFFF

Color

#5B9BD5

Transparency

Line

No line Solid line Gradient line

Color

#41719C

Transparency

Width

Weight preset

Sketched style

Compound type

Dash type

Cap type

Join type

Begin Arrow

Begin length

Begin width

End Arrow

End length

End width

Shadow

Color

#000000

Transparency

100%

Blur

4pt

Angle

45°

Distance

3pt

Reflection

Presets

Transparency

100%

Size

55%

Blur

0pt

Distance

2pt

Glow

Color

#5B9BD5

Size

0pt

Transparency

60%

Soft Edges

Size

0pt

3-D Format

Top bevel

Widthpt Heightpt

Bottom bevel

Widthpt Heightpt

Depth

#666666 Size pt

Contour

#333333 Size pt

Material

Lighting Angle °

3-D Rotation

Presets

X Rotation °

Y Rotation °

Z Rotation °

Perspective °

Keep text flat

Distance from ground pt

Size

Height

Width

Rotation

Flip

Scale Height

Scale Width

Lock aspect ratio Relative to original picture size

Properties

Move and size with cells Move but don't size with cells Don't move or size with cells Print object Locked Lock text

Hyperlink

Address (URL)

Ctrl+Click on shape to follow

Text Box

Vertical alignment

Text direction

Autofit

Do not Autofit Shrink text on overflow Resize shape to fit text

Internal margin

Left

Right

Top

Bottom

Wrap text in shape Allow text to overflow shape

Picture Corrections

Sharpness

Brightness

Contrast

Picture Color

Saturation

100%

Temperature

6500

Recolor

#5B9BD5

Recolor tints the whole graphic (same as Graphics Fill).

Crop

Crops the graphic toward its center (Graphics Format → Crop).

Text Fill

No fill Solid fill Gradient fill Picture or texture fill

Color

#000000

Transparency

Text Outline

No line Solid line Gradient line

Color

#000000

Transparency

Width

Shadow

Color

#000000

Transparency

100%

Blur

4pt

Angle

45°

Distance

3pt

Reflection

Presets

Transparency

50%

Size

50%

Blur

0pt

Distance

0pt

Glow

Color

#5B9BD5

Size

0pt

Transparency

60%

Soft Edges

Size

0pt

3-D Format

Top bevel

Widthpt Heightpt

Depth Color

Material

Lighting

3-D Rotation

Presets

X Rotation°

Y Rotation°

Z Rotation°

Text Box

Vertical alignment

Text direction

Autofit

Do not Autofit Shrink text on overflow Resize shape to fit text

Internal margin

Left

Right

Top

Bottom

Wrap text in shape Allow text to overflow shape

Format Axis

Fill & Line is not available for chart axes in SumSheet yet.

Effects are not available for chart axes in SumSheet yet.

Size & Properties are not available for chart axes in SumSheet yet.

Axis Type

Automatically select based on data Text axis Date axis

Vertical axis crosses

Automatic At category number At maximum category

Axis position

On tick marks Between tick marks Categories in reverse order

Tick Marks

Interval between marks

Major type

Minor type

Labels

Automatic Specify interval unit

Distance from axis

Label Position

Number