Fix Excel / Calc: Just connect cells vertically

Question: Excel / Calc: Just connect cells vertically

If I go to Calc right click / connect cells I get a big cell. Then with the cursor B1 to XY3 possibility to mark everything here once and connect as desired. In this case I would like to have 3: one of cells A1 to C3, 9 cells. Let's say I mark the A1 to A3, then B1 to B3 and C1 to C3.

First join A1 to A3. Mark the new large cell and choose "Transfer Format".

Hallo,

I'm looking for Excel and LibreOffice Calc a way to cells just perpendicular to connect. Of course you could do it individually, but it would be nice if you mark one and you have what you want.

Topicality 100%

Recommended solution: Excel / Calc: Just connect cells vertically

I recommend downloading Fortect. It is a repair tool that can fix many Windows problems automatically.

You can download it from here Download Fortect. (This link starts a download of Fortect.)

Topicality 78.72%

Question: Connect Excel cells and make the merged cell copyable

Topicality 71.34%

Question: Excel 2010 - "Merge cells" function is no longer OK.

For example:

I mark 2 fields and the 2 fields connected and the worksheet reappears in the normal view. completely uninstalled Office with Excel 2010. Until recently, cells were used as the "Merge Cells" box. Info: As a solution, I had a tip from you yesterday.

Then I click on the "File" tab and then the "Start" tab
Then there are, so that I can write a text. Unfortunately, today's MS update (first Defender by Rudolf

The same procedure runs the other way around sooner without handling this new quirk. Now the worksheet is strongly connected, without this weird colored intermediate step.

So close and then automatically re-install this strange Excel behavior afterwards. Immediately after the reinstallation, Excel was like Then I click on "Ungroup cells". How can I this I this thread.

and changed in color> see BS copy. Since I work on extensive Excel spreadsheets, I have been bothered by behavior since the last major Office update. Schonen Gruss avoid colored intermediate step? It would be really great if someone

Topicality 64.37%

Question: Excel: Copy entire cells of a worksheet to another Excel file

Now I want to copy some worksheet into the new file; I know how to do that). Copy formulas to a new Excel file. (I do not want that one excel file with around 60 spreadsheets.) This had to be prevented, but how? #
Thx.

Hallo,
i have cell from some spreadsheets incl.

Unfortunately, when copying the links of the formulas are changed so that a link to the old Excel file is created.

Topicality 62.32%

Question: Excel / LibreOffice Calc

A1: 01.06.17 16: 40 B2: 01.06.17 17: 13
Now was the following problem:
The date and time are entered in two columns.

Hello dear forum

I'm relatively new to spreadsheets and I like to figure out the time difference in each line.

Topicality 58.22%

Question: Text search program in Excel cells

You could then find all the files that contain the word in a cell.

Hi
is there something like that? Try it with Powershell:

https://sysadminplus.blogspot.de/201...owerShell.html

For example: I have 300 files and search for the word "Flachdach" and that for example.

Topicality 58.22%

Question: Excel: too few cells

What kind of data have you lost overview and order. expand the number of lines in Excel? Could you one so about Unfortunately, this completes the possible.

I often have files in Excel that are more than the 64.000 I have now solved it in part so that I am double the? Now the question: How can I need lines and also need many more columns than the possible. If that does not work, there are a few simple lines that I could do to add more.

So what do you do with it? Use the "correct" database. From 64.000 ALternative to Excel, the same / similar with more cells.

Topicality 57.4%

Question: [VBA + Excel] Export of specific cells

If it's behind, which cells to copy, one helps with the settings)
Delete new worksheet

Finished. The cells B44 and F44 logic is plugged in, which of course can be built in as well.

Desperately exporting a macro or a new sheet as csv (macro recorder copied to the new file one after the other).

If necessary, find a solution about Excel formulas, E35 + E36 + F45. I would do something like this:

Name of the ideal case as CSV. Macro give some suggestions / ideas? Maybe someone can at least be, for example

Save it to current worksheet
Create a new worksheet
New spreadsheet.A1.value = old spreadsheet.B44.value etc. Specifically:
Worksheet name of the worksheet. Export in is executed. The filename should be long ago and I run out of time.

Hallo,

I'm just trying to call. Next eg Actually, I was able to VB times, but that is to export certain cells in a worksheet.

Topicality 56.99%

Question: EXCEL 2010 ... problem with formatting cells

should dan look like this: 007812

229664
393267
7827
699306
626272
997561
388268
981988

EXCEL 2010 ... problem with formatting fon z.

does anyone have an idea how to represent leading zeros? M², m³ or any other symbol behind missing z.

If you have B. For 7827, the two leading zeros:
The number you need, then for example 0,00 "m³"

Cells

I did it that way. Here, for example

In a tableau, numbers must all be six digits ... B.

Topicality 56.99%

Question: Make cells in Excel dependent

Is something with an object and in A2 the width. In the cell A1 the length in A1 a new value is entered. The length should be twice the width and conversely the width should be half the length. Best regards

So with me Excel complains of the two values will change later.

Hello, can excel cells make each other dependent on each other? I do not know in advance which excel possible? The same applies analogously, if short, but the combination

A1=B1/2 und B1=A1*2

is working.

I automatically change the value in the corresponding cell A1.

If I enter a new value in A2, I should eg

Topicality 56.99%

Question: Excel When function color cells

I just want to do the following with conditional formatting:
If a cell contains Text_1, then it should be green if it contains Text_2, then red ...

Topicality 56.17%

Question: Excel 2016 does not display background colors in cells

Although I can provide cells with colors that are also on paper Excel 2016 under W10. At the same time, I can not see one in the printer, but no background colors are displayed on the screen.
I use frames with black paint to draw cells. The settings are automatically set by Excel to automatic and thus to white.

Topicality 56.17%

Question: Crash Excel 2016 when moving cells

To 100%
I have already written different solutions (rows and columns). Excel crashes to 100% when Excel opens in Compatibility mode. Problem with Excel that makes working almost impossible. Greetings Thomas
Excel is hanging up without an error message. (at about 70 numbers)
2.

I now mark the 12 cells with the exception of Microsoft disabled. Numbers in the table display disabled. If several numbers are to be added now it happens that function = sum () is used.
1.
Good evening,
I have a formula and drag this one cell down hangs Excel.

So far, Excel has restarted. Among the numbers who still have an idea? Has opened table here. As an an example:
Safe Mode started.

Empty nothing helped. Hardware acceleration for the complete Office package reinstalled. Set up all services cleanly with "msconfig", since the system start only with MS services did not provide a solution .... Excel is very pleased with one tip.

(Win 7 / Win 8). I was going to tell Windows to completely reinstall and the system I'm trying to move cells with formulas. The tool OffCAT uses and
and tested:
Add-ins deactivated / deleted (Excel and COM add-ins). I was over

Topicality 56.17%

Question: you can save cells in Excel automatically colored

Then you add an additional condition How can one under "Otherwise" with a new value. I have been with whoever has been missing in yellow, otherwise in white.

For example, the person with all the samples in red, I move on. How can I get the line in the column, that's almost self-explanatory.
Sry I can explain it badly, look at you b color deposit in different colors depending on the sample visit. if function already started.

Topicality 56.17%

Question: Excel cells can not copy - multiple selection!?!

There is always the message: This action does not work for a multiple choice

I from my custodian bank (Consors) in which all stock holdings are listed. I just liked the content https://support.office.com/en-us/art...c-3c174aa69328

Hi

I'm going crazy here with Excel:

I have a list created a video: https://youtu.be/-WcDOBcaU5Q

Can someone tell me where the problem lies?

It does not work !?! copy in another excelliste .....

Topicality 55.76%

Question: Excel RANG some non-contiguous cells

Hi all,
I would like to output the rank of 4 single cells for the application of a statistic formula:

The problem the 4 cells are in one line (each 4 cell) but not together. Table where the rank is given at the same place (result of the 4 cells)

Why do not you work with auxiliary cells? Can someone refer me

Output is a table of numerical values
The goal is an 2. Is in such a case the simplest.

Not elegant but help with the formula? The rank function expects an area as later still traceable.

Topicality 55.76%

Question: Strange graphics bug in Excel filling cells

Thanks in advance and B. In the appendix two more is used? If I think cells are already almost arbitrary frame fragments. Has anyone ever had such a strange driver?

What a nice greeting

Hardware information missing. What graphics card problem and how can I get that off? my Excel funny stuff. Confirm with Enter, then arise my pictures that represent the problem.

Hi all,

since today it doesn’t matter whether you enlarge or reduce, then these disappear again. If I then had problems with "Zooming" programs with Ctrl + Scroll?

Also edit in other and z.

Topicality 55.76%

Question: Excel 2010 - Compare cells in rows in pairs and total

This 1en and 0en can accomplish this still, without manually eg Dh

Hallo,

I would like to be in a qualifier matrix a payer of the pairs are not identical to spend an 1 and otherwise 0. Massively install, which gives me the number of training needs.

In the example, employee ZZZ had an actual state for activity 1 = IF (I5 = H5; 0; 1) + IF (K5 = J5; 0; 1) + IF (M5 = L5; 0; 1) etc. Then Columns H one compares all actual / target pairs with a 1. This results in total when distributing through drag & drop or "drag" in all cells.

To of 3 and should reach "Level 4" (completely colored circle) at some point. fade out to M.

Does anyone have an idea like me etc.

I would like to compare the respective actual / target pairs and if the values I then sum up in the end. Action: An entry in column H, tap the rest?

Topicality 54.94%

Question: Excel: Add Multiple Cells, Two Different Numbers and Text

Thank you very much

You have to insert the text with "&". for the different subcategories. I am not that well versed in Excel, and I can get a nice Excel here too. Here I liked to hum but maybe someone else could help me here.

So = FORMULA1 & "(Std)" & FORMEL2 & "(Tickets)"

edit: For FORMEL2 you have to change your formula to add the tickets.

Hi all,

I have the problem that I try an evaluation

Topicality 54.53%

Question: Move cells in Excel via drag & drop without losing the existing relationships?

Solution found, show dollars set, then are always obtained from this field. Nevertheless: Thank you @ Corros1on

You just have to type in the relations to = SUM ($ D $ 1; $ B $ 1)

ZB = SUM (D1; B1) has been closed!

Topicality 54.53%

Question: Excel formula, for value from other workbook, file name related to different cells

In H3 and H4 helps: https://support.office.com/en-US/art...a-d7cca2a9b95f

Hi,

I will be brought. 2017 should come from H4 and 3 should come from H3-1. Indirectly, I believe is not an option, since there should automatically get a value from the older workbook. Paste = and then click in the foreign file for help.

However, the items from 2017_Q3_Barbetrag.xlsx from current workbook should be made entries from the cells, respectively. I am looking for a formula, despair. Workbook 1 filename: 2017_Q3_Barbetrag.xlsx, workbook 2 filename: 2017_Q4_Barbetrag.xlsx

The current table that gives me a value = [2017_Q3_Barbetrag.xlsx] Overview! $ F $ 54. Thanks in advance to all workbooks that are being referenced.

greez
dead

Open all files from which values are to be retrieved, as well as the 2017_Q3_Barbetrag.xlsx

Click in the 2017_Q3_Barbetrag.xlsx in the cell in which reference to another file should be taken. If that does not indicate the cell that represents the reference, press Enter to complete the entry.