Questions tagged [cells]
A cell is generally a reference to one point of data in a spreadsheet program. Every data point is within a cell and cells are then grouped into rows, columns or even ranges.
219
questions
0
votes
0
answers
16
views
Remove contents of cell in Word table, shift components behind it to fill empty cell?
I am searching for a similar solution to the one posted here in which I have a word document with a succession of cells (images with captions in the cells) arranged in an order. The solution on that ...
0
votes
1
answer
66
views
Styles based on Normal display a white background, unrelated to the Borders & Shading
In Word, when I write text in a table cell with a colored background, I see a white background behind my text. I supposed it had something to do with the Border & Shading options, but it was ...
-2
votes
1
answer
70
views
In Cell O6 I am checking to see if cell A6 is a public holiday, is so then place a "1" in cell O6, else "2". However cell Q6 will not calculate
In Cell 06 I am checking to see if cell A6 is a public holiday, is so then place a "1" in cell O6, else "2". However cell Q6 will not calculate.
For some reason it will not see the ...
0
votes
0
answers
85
views
Merge cells in excel depending on the value in another cell
I'm looking to minimize the time required to input information in an Excel worksheet. I have a cell which can have the numbers 1, 2 OR 3 and depending on the value of that cell, I need some cells to ...
0
votes
1
answer
71
views
How to limit the number of characters per line in a cell in excel 2016
I am trying to combine multiple cells into one, however when combining, I can only have 55 characters per line. Is there a way to create a word wrap that will keep my data to 55 characters per line?
0
votes
2
answers
70
views
Copying Sheets and cell references
Let's say I have "Sheet A" and "Sheet B" within the same workbook.
Sheet B has a cell that references Sheet "A" i.e. ='Sheet A '!Q20
I want to copy Sheet B and Create &...
0
votes
1
answer
26
views
How inserting cells in a row or a column different from inserting row(s) or column(s) between rows and columns?
How is this Inserting cells in a column different from Inserting a column between two columns
P.S.: It's a curious question, and didn't find anything on the internet; hence, I don't add any ...
0
votes
0
answers
18
views
Highlight range when press another cell
If countif example "done" range example from A1:A10 and result appear in cell B1
If result =4 .
I want when click B1 .. the cells in range that contain "done" highlight and color
0
votes
2
answers
121
views
In Excel, Format a Number with Intermediate Spacing AND Optional Decimal
I have a series of numbers in Excel that I would like formatted in a certain way and I need some help.
Background:
I work in construction, and am using the Construction Specification Institute's (CSI) ...
0
votes
1
answer
114
views
Conditional Formatting Not working (maybe pilot error?)
Excel Version 16.68.
I want to compare numbers in Column D to a Reference Number and use Conditional Formatting Formulas in Column E to highlight the corresponding cells.
I use Formulas because the ...
0
votes
2
answers
369
views
Excel move into data table with enter key only
I need to enter data into Excel using a bar code scanner which add a "enter" key press at the end of the scanned code. I need to scan two codes on a device and link them in a database. ...
0
votes
1
answer
25
views
Spreadsheet doesn't open on the cell active during save
No matter what cell is active when I save this one particular worksheet, it always opens on cell N124. Other worksheets work fine, they open on the cell that was active when I saved them. Any ...
0
votes
1
answer
121
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
0
votes
1
answer
114
views
How to decrease the number of cells that are selected in the formula in Excel?
I'm using the AVERAGE function and drag/expand it along one row (e.g. from A1 to D1), the cells that are selected should decrease by 1 row in each new column.
For example:
A1
=AVERAGE(A2:A10)
B1
=...
0
votes
2
answers
1k
views
the arabic content in the cell excel is not shown correctly
The Text is in the cell is well written and when you click on it is is correct as shown in the upper view,
On the cell itself it is not shown correctly
For an example:
Cell view: حمدا
upper view : ...