A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

3
votes
0answers
25 views

Is it possible to set up conditional formatted using Excel online?

As per the title really, is it possible to set up conditional formatted using Excel online? The cell's context menu doesn't have the option, and I can't find it in the ribbon either. Am I missing ...
1
vote
0answers
15 views

How to use dot as splitter in currency format with Russian locale

I want to write currency in the format: ₽ 3 812.23 But if I select Russia as region in the table settings and format the string ₽ 0.00 result formatted number like ₽ 3 812,23 with a comma, ...
1
vote
0answers
12 views

Drag to change referenced cell in Google Sheets as Libre Office Calc does?

In LOC when double clicking cell A1 that has the formula '=B1*C1', both B1 and C1 have a coloured border that is drag-able. Dragging B1's border to D1 now makes the formula in A1 '=D1*C1'. In Sheets ...
0
votes
0answers
24 views

How to freeze a row until a similar row shows up on Google sheets?

I would like to make an effect similar to how for example iOS apps persist a table's row until someone has scrolled beside it. example This behavior happens all the time in iOS apps. You can see ...
-1
votes
0answers
18 views

Highlight the cells used in a formula in Google Sheets

I want to highlight the cells that're used in the formula of a given cell. Let's say I want to apply conditional formatting on B12 which has value =A12+C3. Now I want A12 and C3 to be highlighted.