DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

0
votes
1answer
367 views

Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data". In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...
0
votes
1answer
40 views

Command codes in windows

Here is this article there is a description how to configure a key on Microsoft keyboard. In the article there is a concrete direction what codes assign for specific operations - namely for Next and ...
0
votes
0answers
67 views

Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g., MONTH | CODE | VALUE 1 | aaa | 111 1 | bbb | 222 1 | ccc | 333 2 | aaa | 1111 2 ...
1
vote
1answer
89 views

Word 2010 Macro help - Convert table to fit print layout width

I have a bunch of word docs that I've converted from HTML, which look OK in web layout, but when we switch to print layout, they are chopped off on the right hand side. I have a macro I use to convert ...
1
vote
2answers
356 views

Cumulative average using data from multiple rows in an excel table

I am trying to calculate a cumulative average column on a table I'm making in excel. I use the totals row for the ending cumulative average, but I would like to add a column that gives a cumulative ...
0
votes
2answers
103 views

set hdd flag to boot in linux now mac will not read the exfat filesystem

I was trying to read an exfat file system in linux and removed the original flag of lba.then remembered I had to install exfat-utils. The drive is still exfat but now will not mount to OSx mountain ...
5
votes
2answers
522 views

How to convert embedded excel sheet to word table?

We receive word documents from clients that will sometime contains Embedded Excel Object(sheet) and we need to convert them to word table so that we can then import the documents in InDesign properly. ...
0
votes
1answer
266 views

Lotus Notes : How to set column width when creating a table in vbscript or javascript?

I tried applying the AppendTable method as described in this article for the IBM Lotus Domino Designer. While i have successfully created the table with fixed width, I cannot manage to pass the array ...
-2
votes
1answer
470 views

Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...
1
vote
2answers
3k views

Excel VLOOKUP by second column using table name as range

Using the example table below, I can use the formula =VLOOKUP("ABC123456",Table1,3,FALSE) to lookup the Demand value, but I want to do be able to perform the lookup by using the Cust Part field ...
0
votes
2answers
252 views

Format data as a table in bash

I have an array of JSON data being printed to the terminal (OS X) and I want the properties of that to be displayed in a table in the terminal. Sample query: aws ec2 describe-instances | jq '[ ...
1
vote
0answers
105 views

In Word 2010, what's the secret to getting captions to appear near the table they're describing?

I'm working on a document that has 3 columns throughout, with sidebars and tables sprinkled about quite liberally. The layout requirements are really beyond what I think Word was designed to do, but ...
1
vote
1answer
64 views

How to get access into table mode?

An Access database is getting to much data through forms so new copies get made. To make the old data available for searches the tables should be linked. The problem is that the menu group "EXTERNAL ...
3
votes
1answer
259 views

How to configure the table width inside a landscape page header to be 100%?

I have a Word 2010 document with both portrait and landscape pages. I have a table in the page header, with its width set to 100%. The problem is that on the landscape pages the header table is only ...
1
vote
1answer
222 views

How to select one table column in MS Word printed PDF document

I've got a lot of PDF like this: Jogn Doe Carol Black Street 1 Street 2 City OtherCity The data in MS Word 2010 source are formated as a ...
0
votes
1answer
48 views

Excel Date Manipulation Function

I have an excel table that contains start times and end times and the added hours. Here is what it looks like *********************************** * Start Time ** End Time ** Hours * ...
0
votes
0answers
43 views

Problems in Office Word Mail Merge

In office word 2013 I am creating a sales directory for a business by creating a table in the mail merger and attaching it to an excel document. I was wondering if there was a way to create a break ...
0
votes
1answer
69 views

What is the error return value of a JD Edwards calculated table with multiple return segments?

We're trying to implement an Assembly Inclusion Rule in JD Edwards EnterpriseOne 9.1, by using a calculated table that returns multiple segments. It seems to work fine when the table has a valid entry ...
1
vote
1answer
1k views

PivotTable — how to sum the result of a countif formula by group?

Current Setup A table (Table1) that has the following fields: Organization Name Person Name Several fields that users can put an "X" into (each represents a "module" that users would need access ...
0
votes
2answers
71 views

Excel - Divide informations

I have an excel file with several rows (about 1k). Each row describe some action of one user and (my bad) for differents actions there are differents rows. Something like this action ...
1
vote
1answer
111 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 ...
0
votes
2answers
843 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
379 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
250 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
92 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?
1
vote
1answer
829 views

Cannot delete “hidden” table in word 2013

I have a large document that was originally created in word 2010, and having been editing it for some time in 2013 (on windows 8). I recently moved a table by selecting it, cutting and then pasting ...
0
votes
1answer
88 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
117 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 ...
0
votes
1answer
2k 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
6k 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
4answers
9k 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
1k 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
726 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
93 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
74 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([£ ...
0
votes
1answer
3k views

How to properly align text between table columns in Microsoft Word?

I'm working with a large table in Microsoft Word 2010. It's a pretty simple table, consisting of two colums. In the left column, I have keywords. Those keywords are linked to a specification (portion ...
1
vote
1answer
557 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
683 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
96 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
526 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
78 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
127 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 ...
2
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
90 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
241 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
353 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
121 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
31 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 ...