4
votes
Accepted
Excel 2010 - Vertical alignment of text simply not working
It's a known issue. See here: https://support.microsoft.com/en-us/kb/169101
This problem occurs if the cell is not large enough to display all of
the text it contains.
Text will not bottom-align ...
- 22.4k
3
votes
Accepted
Inconsistent spacing in table of content headings
Looks like an issue with spacing, probably the tabs (using show/hide code button in paragraph section of ribbon to show formatting would show arrows for tabs). Notice how the spacing after the ...
- 71
3
votes
Accepted
How to align taskbar icons to the left
Right click on the task bar and uncheck "Lock the Taskbar".
Restart the computer and see if if is now at the left.
If so, Lock it again to keep it that way
- 44.2k
2
votes
Accepted
How to align a long title in a table of content so that it won't be over page numbers
This is possible. You have to manually edit the indentation and tab rules for the TOC style that you want to modify.
Open the Styles pane.
Right-click the style that you want to modify.
Click Modify....
- 5,776
2
votes
Excel: how to align matching values between two columns and space out the differences
Sorry to waste people's time, but after doing even more online searching I found a solution to my own problem.
I found this site below that offers a VBA solution to the problem I was facing. The ...
- 31
2
votes
Microsoft word alignment in paragraphs
You need to justify your text, then indent the first line of each paragraph.
Select all of your text using CTRL+A. Now press the Justify icon under the Home tab.
Then on the first line of the ...
- 4,744
2
votes
storage device alignment -- calculate the alignment of subsequent partitions of an optimal aligned 32MiB
This optimal I/O size is wrong, the bug is referenced many times like
on ubuntu,
on redhat.
Th more informative may be this blog page.
In any case this 65535 is only the maximal value on two bytes, ...
- 121
2
votes
storage device alignment -- calculate the alignment of subsequent partitions of an optimal aligned 32MiB
Some say that it is important to align SSDs along the ERASE BLOCK and NAND PAGE SIZES.
evo 840 apparently has uncommon erase block and nand parameters: 1536kb and 8k
I'm not certain of the 850 (...
2
votes
Accepted
storage device alignment -- calculate the alignment of subsequent partitions of an optimal aligned 32MiB
Using GPT fdisk Tutorial gdisk it automatically calculated the alignment of subsequent partitions when prefixed with +, for example,
Last sector (8390656-15634398, default = 15634398) or {+-}size{...
- 51
2
votes
Align equation to bracket in Microsoft Word
Press Alt + = to insert an equation box. Or for mac user may use Ctlr + =.
Then, write
\cases (&sin(\alpha-\varphi)=0 \Rightarrow \alpha-\varphi-0@&-l_m e^(t/T_a )=0 \Rightarrow l_m=0)
- 21
2
votes
Align equation to bracket in Microsoft Word
It depends on how you got the double-height curly bracket in the first place. Here is a way to do it starting from scratch.
From this Microsoft Answers article:
Press Alt+= to insert an ...
- 1,939
2
votes
How to 4k align hard drive with pre-existing partitions - Linux, Windows partitions
The logical sector size is 512 bytes, so in order to be 4k-aligned (to match your physical sectors), the partition's starting sector must be an exact multiple of 4096⁄512 = 8.
So just go through all ...
- 415k
2
votes
How to 4k align hard drive with pre-existing partitions - Linux, Windows partitions
How to verify if it is 4k aligned?
Let's take /dev/sdb1 as an example. It starts at the logical sector 233455616. Your logical sectors are of the size 512 bytes. Sectors are numbered from 0, so there ...
- 67.7k
2
votes
How do I rotate certain pages of a PDF to a particular direction?
If anyone is looking for a command-line tool to do this, check out pdftk server.
It's free from PDF Labs. They say:
PDFtk Server is our command-line tool for working with PDFs. It is commonly used ...
- 407
1
vote
Align equation to bracket in Microsoft Word
Add spaces at the end of the second equation.
The entire string will stay centered, but the relevant equation will be shifted leftwards due to the introduction of space characters.
- 11
1
vote
Accepted
Prevent thin spaces to widen when paragraph is justified in Microsoft Word
In Word 2016 this is no longer an issue, however in previous versions like 2010 it is.
The problem can be solved by replacing each THIN SPACE by a NARROW NO-BREAK SPACE (U+202F). Use Find and Replace ...
- 2,018
1
vote
Accepted
Align two images vertically in Word
One advantage of using the following approach instead of a table is that the images can overlap.
Click one image, and then hold down the Shift key while you click the other. Then, on the Picture ...
- 2,424
1
vote
Align two images vertically in Word
I ended up creating a table and centering the contents. It worked perfectly.
- 23
1
vote
Trouble figuring out optimal alignment of multiple partitions on a 931.5 GiB external Advanced Format HDD while in Linux
In case you are still confused by the bizarre number 65535s.
I am also confused by this question recently. I searched for an answer and came across this one: http://gparted-forum.surf4.info/viewtopic....
- 181
1
vote
Align rotation of text with straight connector in Visio 2016
To align the text with the connector set the section Text Transform cell TxtAngle to =ATAN2(EndY-BeginY,EndX-BeginX)
- 2,133
1
vote
alignment of two different column based on a set of data given
You can use Vlookup:
=IFERROR(VLOOKUP(E3,$A$2:$B$4,2,FALSE),"")
Where $A$2:$B$4 is the array of Data you want to use
False to have the exact value
2 is the second column in Data
IFERROR to remove ...
- 2,524
1
vote
Accepted
Microsoft word alignment in paragraphs
It's kinda hard to figure out what you want us to help you with, but I assume you want to justify your text, or make the right side flush to the margin.
Select the part of the text then do Ctrl Shift ...
- 795
1
vote
Accepted
How to align a column of cells by a symbol
Please create the helper column with the following formula
=REPT(" ",10-FIND("±",A1))&A1
where A1 - your original string and 10 - the maximal number of characters before "±" in your data
Then ...
- 441
1
vote
Text to columns Data alignment
With data like this in column A:
Running this short macro:
Sub ReFormatData()
Dim N As Long, i As Long, st As String
Dim j As Long
N = 15
For i = 1 To N
st = Cells(i, 1)....
- 19.2k
1
vote
How to proper align table of contents in Word 2013?
This problem also occurs in Word 2010, so the solution may be the same. Try setting right indent for the paragraph that makes problem (e.g. to 0,5 cm, see the screenshot). The last word of the line ...
- 1,142
1
vote
How can I get Skype to show all chat messages on the left?
If you are still facing this issue in Skype. Right click mouse in the Chat message typing window and choose the option "Right-to-Left" reading order.
enter image description here
- 111
1
vote
Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel
How about INDEX and MATCH?
Tutorial:
http://www.mrexcel.com/articles/excel-vlookup-index-match.php
You can do a MATCH in one column and use that in the INDEX function for the other columns in the ...
- 203
1
vote
Alignment of characters in Word or Excel table
In Word I achieved something similar using tabs. For example, I wanted a series of rows to align on the multiplication symbol. To do this I put a right-aligned tab at 2 cm, a centre aligned tab at 2....
- 11
Only top scored, non community-wiki answers of a minimum length are eligible