Tagged Questions

DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

1
vote
1answer
127 views

Word 2010: Position table after paragraph if enough space

I have a problem with Word 2010 and the positioning of tables in my manuscript. I need to position the tabe after they are referenced in. However, if there is not enough space to place the table after ...
1
vote
2answers
1k views

MS word splits my tables

I am making some revisions to a document in Word. That document is split into sections with headers. The last section has a paragraph followed by a table. The revisions I am making are in the ...
0
votes
1answer
564 views

Access: How to match/relate records to each other within the same field?

In my Access Database is a table with project information, the ID is 'projectnumber'. I want to be able to match/link/relate different projectnumbers (all stated in the same field) to each other. So ...
1
vote
1answer
384 views

Split a table in Word without losing row title

Word has the feature to repeat title row of a table when a table is so long that it spans a bunch of pages. I need to categorize my data into several pages, and I did that by splitting the table and ...
2
votes
0answers
107 views

Specify Row Height in Table Style Gallery

I am creating a new table style in Word 2010. I'd like to specify the row height, but the box is grayed out. Is there a way to add a specifies row height to a table style?
0
votes
1answer
154 views

Open Office Calc formating table

Instead of data, I would like the first row to be the names of the columns. How can I do this? One of the reasons I want this is so that if the rows are rearranged the names wont be jumbled up. I ...
1
vote
2answers
155 views

How to enable page-preaks in tables with captions?

When I add a caption to a table, no matter the table's settings, the table goes to next page. I want instead it to respect the text flow and just go to the next page when needed. If I do not add the ...
-1
votes
1answer
3k views

How do I insert a row into the middle of a table?

I got two pieces of A4 paper in ms word i want insert 2 name in each part using Mail Merge wizard I create the following table in an Access database: but when i try to insert name in ...
1
vote
2answers
9k views

How do I perfectly center a table on the page in Microsoft Word?

I'm trying to insert a table in Microsoft Word. The entire page would consist of only this table, and I want it to be perfectly centered (both horizontally and vertically) on the page. I'm not having ...
0
votes
5answers
13k views

How can I copy/paste the *formatting* of a table in Powerpoint?

I'm wondering if there's a feature in ppt 2010 to paste the formatting of one table onto another (e.g. table borders, cell background colour). I've tried all the paste specials but nothing seems to ...
0
votes
1answer
2k views

Adjust picture size according to table width in Word 2010

When inserting a picture into a table the picture exceeds the table width. I can achieve making it fit into the table by resizing it manually. I was wondering if there is anything like a "fit to ...
1
vote
1answer
930 views

Transpose table in Word

Is there a way to transpose (swap rows and columns) in post-ribbon Microsoft Word (currently using 2013)? For example, in this table, I want the top headings to go on the left (én, te, etc), and the ...
2
votes
0answers
120 views

MS Word - Hidden Table Re-appears After Save, Close, Open

I have a Word document with a table at the top of the first page that I want to hide by default (it contains maintenance information and notes that doesn't always need to be shown). If I select the ...
2
votes
0answers
76 views

Microsoft Access 2010 - error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
1
vote
1answer
900 views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
0
votes
1answer
905 views

Formula to copy a specific character from one cell to another

I am using MS query to pull in data. I need to create a column that copies the first character in another column. For example: Cell A1 - E00633 Cell A2 - B00842 Cell B1 - I want this cell to ...
1
vote
0answers
115 views

Copy a cell from one part in a table to another

By copy I mean with formatting and everything attached. More importantly, I wish to be able to copy the fact that I am pasting 2 cells where one used to be (i.e. split cell). Is there a way to do ...
0
votes
1answer
634 views

Move The New Record Entry Row In Access Table To The Beginning Row

Is it possible to move the "New Record Row" in an Access table to the beginning of the table? For example, say you have 200 items entered into your table, you would have to scroll the whole way down ...
1
vote
1answer
86 views

Microsoft Word - Styled Textboxes In Tables

I am trying to create a template for word documents for my University notes. I downloaded a template for a resume the other day and found this lovely effect where a textbox takes up the entire table ...
0
votes
1answer
156 views

(MS Word 2010) Text Wrap a Picture in a Table

Modifying a table to insert a picture in one cell. I can not set text wrap. I noticed the doc was in compatibility mode, so I did a save as and unchecked the box to keep compatability on. That did not ...
3
votes
1answer
2k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
2
votes
2answers
93 views

Creating A Log Of Files In A Folder

I am an absolute newbie in this thing. Can anyone help me to build a table that lists all files in a specified folder so whenever a file is copied to that folder the table should update. I need the ...
0
votes
1answer
288 views

Can I force MS Excel table column to use the specified pattern?

I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not ...
0
votes
1answer
2k views

How to extract unique data from cells in a single column with thousands of similar values?

I have a single column in an Excel sheet with around 25,000 cells (numbers). Most of them are identical that in the end there are only - I guess - maybe 200 different numbers. Is there a way to ...
0
votes
1answer
419 views

Need to skip certain cells when tabbing through a MS Word Table

I have WORD 2010 on my machine. I am trying to tidy up a table we use alot. It's a very basic document, but has a lot of fields that need to be filled out, though for every field, there is a label ...
1
vote
2answers
3k views

How to copy an unformatted table into excel?

I want to copy the following table http://www.fifa.com/mm/document/classic/awards/01/36/25/40/ballondor_award_men_player_finalx.pdf into excel but when I do it doesn't format it as a table as the ...
3
votes
1answer
127 views

Excel file links through SharePoint

I'm working for a small company which manages it's knowledge throughout Excel files. Some of the files contain data from other files, for example our orders file contains products that are saved in ...
0
votes
1answer
33 views

Excel Statistical Table

I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of ...
0
votes
1answer
170 views

Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)

I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. ...
1
vote
2answers
227 views

Merged rows in column, bottom row fixed height

I've been struggling some time now with a specific problem using Tables in MS Word (2010). I have a table with 2 rows and 2 columns and the last column, the rows are merged. Now it can happen that ...
0
votes
2answers
47 views

getting data from several columns in a record

I have excel sheet contains the following table: I want to get the last recent DATE with its LAB Result?
4
votes
1answer
1k views

Interactive console based CSV editor

Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
0
votes
1answer
93 views

How to create a table with blank borders in Word 2003?

I cannot seem to find any way to create a table with blank borders in Word 2003. Is this possible, and if so, how?
-1
votes
1answer
914 views

How to add a table beside text on multiple lines in Word 2010

Basically, I'm working on a resume and having a hard time getting the layout I want. I have a title for my coursework section called "RECENT COURSEWORK", with each word on a separate line. I want a ...
0
votes
1answer
53 views

Convert text to table

I would like convert text into a table. Here is a link to the text http://www.tcdb.org/public/tcdb Short example: >gnl|TC-DB|A0CIB0|1.A.17.3.1 Chromosome undetermined scaffold_19, whole ...
0
votes
2answers
6k views

hod do i grep multiple keywords from a file?

I want to use unix's grep function to pull out multiple lines (with different key words) from a file in one command line. e.g. i have something like doc-A1-151 file-A2-15646 table-A3-1654 ...
4
votes
1answer
5k views

Restricting table cell resizing in Word

Is it possible to restrict users from resizing the cells of a table in protected documents in MS Word 2010? I want to restrict them from making any changes to the layout of the table (or, at least, to ...
1
vote
1answer
5k views

How to make a color gradient in a Word 2010 table cell

I would like to make a gradient background in a Word 2010 table cell. Unfortunately, Word only provides solid color filling and premade patterns. There does not seem to be an easy way of doing this. ...
1
vote
1answer
512 views

MS Word 10 table won't delete

I created a table. Now everytime I start Word 10 the initial table I started with comes up instead of a blank document. I have tried many different ways to delete the table but everytime I re-open ...
3
votes
2answers
2k views

How to efficiently insert a table from R into a Word document?

I am creating a Word document (.docx) using LibreOffice. I need to include some numeric results I calculated in R. They look like a simple table of numbers, with text captions for the rows and ...
1
vote
2answers
221 views

Any lightweight Linux/Cross-platform text editor that does tables?

I like to organize info in tables. OpenOffice/LibreOffice is too heavyweight, I don't need the hit to swap nor the featureset. Is there any lightweight editor that does a table/grid like that, and can ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
2
votes
3answers
5k views

Excel 2010: How can I obtain a one-to-many rows table by merging duplicated cells in a large normalized table?

As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue - how to get a one-to-many rows table out of ...
1
vote
1answer
4k views

Push cell down automatically in excel (2010) table

I don't know if this is the right forum to ask this I have the following table in excel it is formatted as a table except the total ----------------------------- | Item | Description | Price | ...
1
vote
1answer
99 views

How to make numbered tables with numbers that take no space in Microsoft Office Word?

I have a few tables with symbols in Word and I want to number them, but numbering seems to take a huge amount of space from each box which makes the whole thing look horrible. I can't even see half ...
1
vote
1answer
919 views

How can I stop Word duplicating all the words when I convert text to a table?

In Microsoft Word I have a list of words, one per line, many pages, like below: xxxx yyyy zzzz aaaa bbbb When I copy these lines and paste them into a 1x6 table it becomes like: xxxx xxxx xxxx ...
1
vote
2answers
2k views

How do I group rows in a table by one column's value in Excel?

I have a table of data (5000+ rows) with two columns, ID and value. It may look like this: ID Value 01 02 01 03 01 17 02 05 03 06 03 28 What I want to do is find the average value for each ID. ...
4
votes
2answers
608 views

Using Emacs align-regexp to format tables

Vim has the neat Tabular plugin that allows you to quickly align some text. I use it a lot to align blocks of code along a certain character (mostly things like = and =>). But it also does a very ...
2
votes
1answer
1k views

Multiple tables in Microsoft Access that need to feed into one table

In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
0
votes
3answers
984 views

Excel 2010: Do sortable tables support sorting within multiple columns?

In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't ...