Tag Info

Hot answers tagged

50

Click where the row and column headers meet, this will select the entire sheet, like so: Then double-click any one of the column partition lines. I do this all the time, and it's as quick as you can get.


28

Just leave off the row numbers: =SUM(A:A) Note that this expression cannot be placed in column A (that would cause an endless recursive summation which Excel won't allow). If you instead wanted to sum all of the rows in column A above the current row (say 51) you could do this: =SUM(A$1:A50) If you ever move the cell that holds that expression it ...


14

Using regedit, remove the key HKCU\Software\Sysinternals\Process Explorer, then start Process Explorer. I would suggest to first Export the key, just in case.


11

awk is probably the canonical tool for this kind of problem. $ cat data foo 200 bar foo 200 baz bar 4 baz $ cat data | awk '$2 != 200 { print $0 }' bar 4 baz


8

I don't know about shortcut. I use menu. 1) Select The Full Spreadsheet 2) Select Format 3) Column 4) Autofit Selection


8

Have you tried using Text to Columns? Highlight the column that contains your list. Go to Data > Text to Columns. Choose Delimited. Click Next. Choose Comma. Click Next. Choose General or Text, whichever you prefer. Leave Destination as is, or choose another column. Click Finish. You could also use two formulas in two separate columns. To get the ...


5

Another easy way to do what you describe is to use a table. Turn the borders off and you'll get two columns that are independent of each other.


5

This is the simplest way I would do that with just a formula.... if the values are in columns A and B, then this formula in C1, then copied down as far as you want, it will show blanks when the values run out: =IF(ROW()<=COUNTA(A:A), INDEX(A:A,ROW()), IF(ROW()>COUNTA(A:B), "", INDEX(B:B,ROW()-COUNTA(A:A))))


5

Try this in your ~/.vimrc: au BufRead * let &numberwidth = float2nr(log10(line("$"))) + 2 \| let &columns = &numberwidth + 80 Every time you load a buffer (i.e., open a file), that will determine the number of columns required to show the largest line number, set the 'numberwidth' option accordingly, and set 'columns' to that number ...


5

Try selecting everything (CTRL + A twice rapidly, or just select the columns you want), and then double-click a partition line. In Excel 2007, that solution seems to work just fine; in other words, it automatically sizes each column to its own longest string.


5

Check out this Shell Toy - you can also play with the source code. Shell Column Ex


4

Is it what you are looking for? Convert columns to rows, or rows to columns


4

If the cell you want to reference is A3, make your formula: =$A$3 The dollar signs make the cell reference absolute, so they won't be adjusted relative to where you paste.


4

Using a column break is the easiest way that fits within the structure Word gives you to work with columns. In the Page Layout tab, after you've set up the desired number of columns, in the Page Setup section, click the Breaks dropdown and select the Column break command.


4

Honestly... You're getting more into page-layout than document creation. Word does a better job of doing document creation than it does with page layout. Publisher is much better at page-layouts. You can accomplish the same task in Word... but it appears slightly different than you would expect. Under the "Page Layout" tab... go to Margins -> Custom ...


4

I'm not sure if it's possible to enable the 'Dimension' attribute (nor 'Resolution') to make it just as easy to add these columns to any folder as the "normal" ones. But if you want to add one or both to folders which don't display these attributes then: Temporarily change the name of the folder to any name that starts with the characters "Pictures" (case ...


4

Yes. You need to be connected to an Active Directory domain. Then you can select a range and go Review > Allow Users to Edit Ranges. Click the New button and set a password Click the Permissions button and then add users or groups from your domain address book As with all other cell protection, this only applies after the sheet is protected.


4

cut -sf2 -d' ' list.tab|sed -e 's/\..*/\"/' meaning cut only the second field in lines with separators (space) replace the dot and anything that follows with quotation marks.


3

I think you can just drag the table to where you want it once you've created it. Or more formally try setting the table's position relative to the margin or page, rather than to the column. You will need to play with the wrapping too (probably set it to Around).


3

In my case the fields I didn't want to include in the range actually did have numbers in them. I was stumped until I figured out that you can just sum the entire column and then simply subtract the fields you don't want: =(SUM($B:$B)-SUM($B$1:$B$6)) Where the first six rows of column B are numbers but not relevant to the data I want summed, and column B ...


3

You want an array formula... Assuming your data starts in A1, you can type: =MEDIAN(A1:A3*B1:B3) and the press Ctrl + Shift + Enter to enter it into the cell as an array formula. If you do it correctly, you'll see the formula enclosed in curly braces by Excel.


3

Format the cells with a custom format to always use at least eight digits, so the format would be: 00000000 The Microsoft article Using a custom number format to display leading zeros provides more information that you might find useful. The same method works in LibreOffice.


3

Columns are meant for newspaper-like documents, where you often see multiple columns of text. For what you want, you can make a table that looks like this: |----------------------------| | Very very long word | |--------------|-------------| | First word | second | | | third | |--------------|-------------| | Again very ...


3

Copy/Paste the text into a text editor Replace all space characters with carriagereturn/linefeeds Save as a TXT file. Open the file in Excel.


3

Think of them a bit like database tables. The column names need to be unique. See http://msdn.microsoft.com/en-us/library/bb833052(v=office.11).aspx


3

Excel has a Text to Columns feature that should be able to do that for you. Assuming you have Excel 2007 then select the column you want split, go to the Data tab and click Text to Columns. then select Delimited (Next) and then check only the Space option and click Finish.


3

Input into B3 = C3 * C$2 and then copy down. C$2 is known as mixed cell reference. In this case, as the dollar sign ($) is put in front of the row number (2). It can help to fix the row number when copying. Reference: http://blogs.office.com/b/microsoft-excel/archive/2011/08/17/making-sense-of-dollar-signs-in-excel.aspx Absolute cell references ...


3

The csv.vim - A Filetype plugin for csv files also supports tab-delimited files, and has :ArrangeColumn and :UnArrangeColumn commands for that.


2

I'd place the hidden cells on another sheet and protect it via VBA such as: Sheets("sheet4").Visible = xlVeryHidden or Worksheets("sheet1").protect "Password", UserInterfaceOnly:=True or ActiveSheet.protect "Password", AllowFormattingRows:=True, AllowFormattingColumns:=True Or other methods. xlveryhidden is a good place to start, then lock the UI and ...



Only top voted, non community-wiki answers of a minimum length are eligible