Search Results

Search found 23072 results on 923 pages for 'microsoft words'.

Page 162/923 | < Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >

• In Excel how can I sum all the numbers above the current cell?

  - by Mark Meuer

  I want to have a column in Excel that consists of a header, a bunch of numbers, and then have the sum of those numbers at the bottom. I'd like the sum to adapt to the insertion of new numbers above the total. Something like this: Numbers 1 2 5 10 18 Total If I later insert 10 new numbers in the middle of the list, I want the sum to automatically include them. I know the SUM() function can sum a whole column, but if the total is also in that column then it complains about a circular reference. How can I just sum the numbers above the total?

  Read the article

• Set preferred host to run on?

  - by maeron

  Hi, We have set up a virtual MS clustered environment and I want to set one virtual machine to run on each physical server. How can I do this?

  Read the article

• Mac Outlook showing all links in smart quotes?

  - by user2727128

  I was given the task of fixing my friend's email today and really don't know what the problem is. When an email is sent from his laptop (Mac) from Outlook the email address link in the signature shows exactly like this: [email protected]<mailto:[email protected]>. Additionally the website link displays like this: www.website.com<http://www.website.com>. And lastly, the image comes through as cid:randomstringofnumbers. When I sent him an email and he sent one back it converted my signature to same weird formatting. Plus, even in the header where it shows our emails, they are displaying the same way: [email protected]<mailto:[email protected]>. And the weirdest thing is that this problem seems to be "compounding". So when I scroll down to the last, most recent email in the thread I see this www.website.com<http://www.website.com> next email shows this: www.website.com<http://www.website.com><http://www.website.com> and the next this: www.website.com<http://www.website.com><http://www.website.com><http://www.website.com> This is happening to the emails too, everywhere. I'm thinking this might be something to do with smart quotes and the auto formatting but I'm not sure. Could this be the problem? And if so how do I fix it?

  Read the article

• Summing of total with dynamics rows coming external datasource

  - by Gainster

  I am using Excel 2010 and retrieving data from SQL analysis service. When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate column with a formula to sum the totals. With an increment or decrement of these rows, the alignment of custom columns goes out. How can I resolve this problem that summing of values become dynamic with adding and removal of rows?

  Read the article

• Moving to the next line to populate an excel file from VBA

  - by edmon

  I have the below code that takes certain fields from my MS Access (A small Hotel Reservation Database)form and populates defined cells in the said Excel file. Dim objXLApp As Object Dim objXLBook As Object Set objXLApp = CreateObject("Excel.Application") Set objXLBook = objXLApp.Workbooks.Open("Y:\123files\File\Hotel Reservation.xls") objXLApp.Application.Visible = True objXLBook.ActiveSheet.Range("B2") = Me.GuestFirstName & " " & GuestLastName objXLBook.ActiveSheet.Range("C2") = Me.PhoneNumber objXLBook.ActiveSheet.Range("E2") = Me.cboCheckInDate objXLBook.ActiveSheet.Range("F2") = Me.cboCheckOutDate objXLBook.ActiveSheet.Range("H2") = Me.RoomType objXLBook.ActiveSheet.Range("I2") = Me.RoomNumber End Sub How can I keep populating a new Guest to the same Excel file just on the next row?

  Read the article

• Two bilbiographies in Word

  - by Jan Aagaard

  Is it possible to have two bibliographies in Word 2007? I want to use the first one as a reference list to external references and the second one to be a list of my own appendices.

  Read the article

• Find rows that match multiple (two) criteria

  - by Scott Sanders

  I am trying to get a list of items that match on two criteria. DATE PRODUCT CHANNEL DEC 13 Cat Chow DRUG NOV 13 Pupperoni DRUG DEC 13 Meow Mix DRUG DEC 13 Jerky Treats DRUG This is the data from A1 to C5. I want all the product sold on DEC 13 and in the DRUG channel. This is the formula that I have now, which is only bringing back the first example. INDEX($B$2:$B$5, MATCH(1, ("DRUG"=$C$2:$C$5)*("DEC 13"=$A$2:$A$5), 0) )

  Read the article

• Searching Excel sheet for errors

  - by Graphth

  Imagine a huge worksheet with tens of thousands of formulas. I want to be able to quickly find all the errors to correct them. I have found that using the normal search procedure I can type in things like #DIV/0! or #NAME? and it will find them, but I would have to type in all the various types of errors separately and that is somewhat time consuming. Is there a way to simply search for any error? One solution we seem to use at work is to put most formulas inside =if(iserror()) or now =iferror() and to just have it output "error" if it is an error. Is this necessary? Or, is there a way to find all the errors without it?

  Read the article

• Problems in Table of Contents formatting

  - by ChrisW

  Two questions about captions in Word (they are related, hence the same post): Using Word 2010 (and its inbuilt equation editor) I've got figure captions which contain equations (well, actually, they represent chemical equations, such as nitrate, for which the correct representation is NO3- where the 3 is subscript and the - is superscript, but in the same column). However, when I generate a figure list, the equation displays as NO3- (with no subscript or superscript) - Word knows it's an equation though (the Equation Tools design ribbon/tab is displayed when I click on the NO3-). I've tried changing it from Professional to Linear and similar other obvious options, but still can't get it to display correctly. File to show this problem in action: http://dl.dropbox.com/u/101867759/EqtnTest.docx - note how the (chemical) equation for nitrate is rendered correctly in the 'caption' on Page 2, but not in the ToC on page 1. I have another caption where the whole figure is included in my list of figures. When I double click on the caption in my text, the caption is highlighted (as expected), but so is the figure (this doesn't happen with any of my other figures) so I assume that the figure has been 'linked' in some way to the text - how do I remove this link?

  Read the article

• Creating a list based on a column

  - by MikkoP

  I need to create a dropdown list in sheet A based on the values in sheet B in column A. I clicked on the A column in B sheet and named it as Models. Then I clicked on the cell in sheet A where I wanted the list to be and selected Data -> Data validation -> Data validation. In the Settings page I selected List in the Allow section, checked Ignore blank and In-cell dropdown. In the Source section I inserted =Models. This way I get all the right values plus a lot of blank values. How do I prevent the blank lines from appearing in the list?

  Read the article

• Recovering a password for a Word 2007 document

  - by Corbo

  I have an old Word 2007 document that I don't remember the password for. I'm guessing a brute force attack is the way to go to get it open. Anyone know of any free tools I can use to do this?

  Read the article

• How to make a dropdown list such that... (see details)

  - by daysandtimes

  I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already. I want to create a line graph in Excel. One line is fixed and that would be the S&P500, and the other would be the company I select. I know how to use data validation to create a dropdown list, but how could I make it in such a way that when I select company A, I would only see company A's price data but not company B, C, etc. Then when I select company B, I would only see company B's price data & the S&P price data. And so on. The S&P line will be visible all the time, but the various company's price line will only appear if it is selected. Is there any easy way to normalize all sets of data in a way such that the starting point is always 100?

  Read the article

• How can I search and replace in word files ?

  - by Tal Galili

  Hi all, I am looking for a way to do search and replace (for free) in word (.doc) files. The softwares I found so far allows me to search but not replace. Any suggestions ?

  Read the article

• Other language Sorting(like hindi, not english) for Excel sheet column

  - by brz dot net

  How can I sort excel sheet column for other languages like hindi(not english)?

  Read the article

• If email not received then do X (outlook 2013 on Exchange 2010)

  - by Brad

  I receive notification emails daily and would like to automate an easier way to manage all of those notifications. For example: Notification 1 from [email protected] is received daily between 10pm-1am Notification 2 from [email protected] is received daily between 12am-3am Notification 3 from [email protected] is received daily between 1am-4am I am looking for a way to page myself at [email protected] on my cellphone if any of these messages are not received within the defined time frame of when the email should have arrived. I would like to basically email a page like: ATTENTION Notification 2 not received within the allowed range. This way I would be notified instead of having to check the email manually and see that I only received 2 of the three alerts. Is there a way to do this in Outlook? Our exchange server is a hosted exchange server on GoDaddy if that info is needed.

  Read the article

• How can I synchronise my Outlook Calendar with Google Calendar (preferably using a free/open source tool)?

  - by Kuf

  How can I synchronise my desktop Outlook calendar with my Google Calendar (Outlook - Google)? I saw the question Free tool for Synchronizing Google Contacts and Calendar with Outlook, but the solution that was suggested there is no longer available - Google Sync End of Life. There are tools that required a payment, like SyncMyCal, gSyncit and OggSync, but I am looking for a free / open source solution. One can download Google sync, but when trying to use it there's an error: For now, I use OggSync to synchronise, but as a freeware it allows to synchronise manually only, not automatically, so I have to remember to synchronise after every change. I checked Mozilla Sunbird, but I couldn't find any relative posts on how to synchronise Outlook - Google using it. Just to be clear: I'm not looking for software; I am looking for a solution. What can I do if sometimes software is a solution?

  Read the article

• How to Sync with Outlook and Google

  - by Astaar

  Recently, Google dropped the support for their Google Sync service. That program was regularly reading your Outlook calendar, parse it, and then modify your Google Calendar to match - effectively synchronizing. This was useful to me because it allowed me to share my professional calendar with whom I chose (namely, my wife). Now I'm looking for an alternative or how to continue a sync using Outlook. Please note I'm not trying to show my online calendar in Outlook. I want to update my online calendar with whatever I have in my Outlook 2010 one. Is there any other way of doing this?

  Read the article

• Can I autofill a pattern that changes periodically?

  - by user234479

  I am trying to create an autofill similar to below, essentially requiring excel to realise that every 3 cells down the row number being referenced increases by 10. I have tried but it does not seem to recognise the pattern. Is there any way around this? ='Book1'!$A1:$D17 ='Book1'!$A1:$D17 ='Book1'!$A1:$D17 ='Book1'!$A11:$D17 ='Book1'!$A11:$D17 ='Book1'!$A11:$D17 ='Book1'!$A21:$D17 ='Book1'!$A21:$D17 ='Book1'!$A21:$D17

  Read the article

• MSWord table shading prints too dark

  - by Relaxed1

  My friend has a very light shading in his MSWord tables. However they still print too dark to read the text. When emailed to a colleague using the same printer, it prints light nicely. However they cannot find any setting that is different between them. Any ideas? Thanks! (P.s. for myself this would help for non-tables also, when 'highlighting' text. I do know that 'shading' gives more colour options for non-tables, but it would be nice to know anyway. Thanks)

  Read the article

• Advanced cell selection in Excel

  - by Supuhstar

  I am new to this flavor of StackExchange, so if this belongs elsewhere, please move it; I figured this would be the best place, though. I am making an Excel Worksheet that simply stores basic financial data in 5 columns (Check Number, Date of Transaction, Description, Profit from Transaction, and Balance After Transaction) and indefinite rows. Each worksheet represents one month, and each Workbook represents a year. As I make or receive a payment, I store it as a new row, which, inherently, makes the number of rows per month indefinite. Each transaction's Balance cell is the sum of the Balance cell of the row above it and the Profit cell of its row. I want each month to start off with a special row (first one after column headers) that displays a summary of the last month's transactions. For instance, the Balance After Transaction cell would display the last row's balance, and the Profit from Transaction cell would display the overall profits of the month) I know that if I knew every month had exactly 100 expenses, I could achieve this for March with the following formulas for profit and balance, respectively: =February!E2 - February!E102 =February!E102 However, I do NOT know how many rows will be in each month's table, and I'd like to automate this as much as possible (for instance, if I find a missed or duplicated expense in January, I don't want to have to update all the formulas that point to the ending January balance). How can I have Excel automatically use the last entered value in a column, in any given Excel spreadsheet, in a formula?

  Read the article

• VBA code to hide or unhide rows based on a cell value

  - by I AM L

  Heres my code, but its not really doing anything, I dont see anything wrong with it: Private Sub PG1(ByVal Target As Range) If .Range("E50").Value = "Passed" Then Rows("51").EntireRow.Hidden = True End If ElseIf Range("E50").Value = "Failed" Then Rows("51").EntireRow.Hidden = True End If End Sub My intention is that when that specific cell in the previous row is set to "Passed" from the dropdown, then the below row would appear, if its a 'Failed" then it'll be hidden instead.

  Read the article

• Automating Access 2007 Queries (changing one criteria)

  - by Graphth

  So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll run the 6 queries for May, as May just ended. I only want the data from the month that just ended, so the query has Criteria set as the name of the month (e.g., May). Now, it's not hugely time consuming to change all of these each month, but is there some way to automate this? Currently, they're all set to April and I want to change them all to May when I run them in a few days. And each month, I'd like to type the month (perhaps in a textbox in a form or somewhere else if you know a better way) just once and have it change all 6 queries, without having to manually open all 6, scroll over to the right field and change the Criteria. Note (about VBA): I have used Excel VBA so I know the basics of VBA but I don't really know anything specific to Access (other than seeing code a few times). And, others will use this who do not know anything about Access VBA. So, I think I have found a similar question/answer that could do this in VBA, but I'd rather do it some other way. If the query needs to be slightly redesigned later, probably by someone who doesn't know Access VBA at all, it'd be nice to have a solution not involving VBA if that is even possible.

  Read the article

• Extract structured data from many MS Word files

  - by Mark

  I have ~160 MS Word files that contain structured data. The data is formatted identically across all files and resides in a tabular format. I'd like to extract the data into a database, XML or just an aggregate table without opening each of the files independently. Is there a tool or method I can use to extract this data?

  Read the article

• Excel formula to compare single value in one cell with multiple values in other cell

  - by Raw

  I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C. For example, using the table below, it searching in column B for values which are less than or equal to 12 and put the answer in same order in column C. Column A Column B Column C 12 0,12,13,14 Yes, Yes, No, No 101 101,102,103,104 Yes, No, No, No How can I do this in Excel?

  Read the article

• Can I filter multiple column headers to display subheadings of each in Excel?

  - by Gigi

  I can't seem to find this anywhere... it may not even be possible without coding? I have a spreadsheet containing more than one heading in a single column. These headings are identified with blue background and white font. Each of these headings have items listed below them. These "subheadings" are smaller, auto-black font and no fill background. Currently I have to scroll down the spreadsheet to view all headers and their contents. How do I create a filter that would allow me to sort on whichever header I want, so that (only) the contents of that particular header are displayed?

  Read the article

< Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >